I made a draft of a WordPress website on localhost using XAMPP. I made a database for it using MySQL. I’m ready to upload to BlueHost. I understand that means I need to save the database as a single .sql or .sql.zip file.
I keep getting the "…UAywaMh-.sql.part could not be saved, because the source file could not be read" when I try to turn the database into an .sql file that I can upload to BlueHost. BlueHost help says that the problem is not on their end. I’ve tried it in Firefox and Chrome. Chrome says "couldn’t download."
I did leave the "New template" and "Existing template" fields blank. Is that it?
I know the name of the database I created and I was able to find it easily in https://localhost/phpmyadmin/ I don’t think I have the wrong one.
How do I fix this so I can get my website live? Thanks!
UPDATE: On GitHub, someone described the same problem and said that patch #17447 fixes it, but I can’t find the patch anywhere. https://github.com/phpmyadmin/phpmyadmin/issues/17445
UPDATE: A GitHubber responded! Turns out the answer is to update phpMyAdmin to version 5.20 or later! The first time I did this, I couldn’t log in, but the trick is to copy over the config.something file!
2
Answers
Posting this so anyone in the future can find the solution.
The problem ended up being fixed by https://github.com/phpmyadmin/phpmyadmin/issues/17445 which was fixed in phpMyAdmin 5.1.4 and 5.2.0. It seems there was a related problem in PHP https://github.com/php/php-src/issues/8218 that caused download issues with some browsers.
Upgrading to the latest phpMyAdmin release was the solution.
From following instruction my problem is solved, I have export the db file.
Goto XAMP Control Pannel
Open > Shell
//Write following command in shell
mysqldump -u [root] -p [BD_Name] > [backup_file_Name].sql
Enter password:
This will ecport your file and filename.sql will save in your xammp folder