Sorry, I filled in the inquiry in the format requested. I keep getting the above error message when i try to upload my current website database into infinity. I am trying to migrate my exsisting site from bluehost to infinityfree. I’ve never done this before and am following the step by step instructions, but keep getting this error message. What am I doing wrong?
It seems that your database backup includes a statement to create the database with the name it had on your old hosting provider. But that’s not going to work if you’re migrating to a different provider, because then the database name is likely different.
This is fairly easy to hack yourself though.
Extract the downloaded backup (or download a fresh one without compression).
Open the file in a text editor (like Notepad).
Find the lines that begin with CREATE TABLE and USE and delete those lines. In your backup, they are lines 24 and 25.
Save the updated file.
Import the updated backup file through our phpMyAdmin.
How do I tell what is supposed to be exported and backed up on bluehost? Where do I find that information to know if anything is missing. I don’t have a huge site and while I have some information on it, I don’t have a lot. Would I be better off just pointing my domain to infinity free and starting over with my website? Would I be able to use wordpress and elementor to build my site? Sorry, I’m just a bit lost.
Were you able to follow the instructions from Admin, or did you get lost?
If you got lost:
Login to your BlueHost control panel and open PHPMyAdmin
Select the database you would like to work with.
Along the top of the screen click the “Export” tab.
Select the options you would like for the export. If you aren’t sure, simply leave things as they are and click the “Save as file” checkbox and click Go.
This will download a .sql file to your computer.
Open the .sql file using a text/code editor
Find the lines that begin with CREATE TABLE and USE and delete those lines. (Use CTRL+F to search for them)
Save the updated file.
Import the updated .sql file through our PHPMyAdmin.