Site Migration help

[TravelingChzhed]

epiz_31179409_MichelleRao
(please specify the website or account you are asking about)

Error Message

SQL query:

``

--
-- Database: `ravelkr9_WPYFI`
--
CREATE DATABASE IF NOT EXISTS `ravelkr9_WPYFI` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci

MySQL said:

#1044 - Access denied for user 'epiz_31179409'@'192.168.%' to database 'ravelkr9_WPYFI'

(please share the FULL error message you see)

Other Information

What am I missing here? Please help! This is my first time doing this!!
(other information and details relevant to your question)

[KangJL]

Write clearly. What do you want?

[Greenreader9]

Welcome!

Is this what you are looking for?

How to migrate your website to InfinityFree

If your website doesn’t use MySQL databases, moving your site is very easy. Simply upload all your files to the ‘htdocs’ folder on your hosting account with FTP or a file manager. If you have a PHP based website, check if it has any configuration files where a domain name or file path needs to be set. Update these values as required. If your website is using MySQL databases, you need to move the database contents as well and update the configuration of your website to use the database: Backup…

[TravelingChzhed]

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?

[TravelingChzhed]

I did follow these instructions, but I must be doing something wrong as I keep getting this error message.

[Greenreader9]

I think you want to do this instead of creating the tables from scratch.

@Admin

• Backup the database on the old host. Log in to phpMyAdmin, select your database and click on ‘Export’ tab. Choose Save as file and select ‘gzipped’. A download of your database backup should start afterward.
• Create the database on your InfinityFree account. Before you can restore a database backup, you will need to create a database on our system. Enter your website’s Control Panel and click on the MySQL Databases. You can create a new database there. Pay close attention to the database name and hostname, as you’ll need them later.
• Importing database data to our server. Once the database is created, enter our phpMyAdmin (the icon for the tool is located in Control Panel). Once inside, click on ‘Import’ tab, browse to the backup file of your database (yourdatabase.sql.gz for example) and click Go. Database restoration procedure will begin. Please be patient, as it can take quite a lot of time to complete if your backup size is large.

[TravelingChzhed]

This is exactly what I did, but I keep getting the error message and have no idea what to do next or what I am doing wrong.

[Greenreader9]

Oh, now I think I understand. The code you shared in the beginning was a snippet from that backup file, right? Can you upload that file here?

[TravelingChzhed]

I think so…ok it says I’m a new user and cannot upload files, so I guess not.

[Greenreader9]

Can you upload it to Google Drive, Box, OneDrive, etc and paste the sharing link here?

Thanks

[TravelingChzhed]

Here you go: HIDDEN BY MOD

[Greenreader9]

Can you try creating a new backup from Bluehost? This one looks corrupted.

EDIT:

It looks like some tables were imported. Are there some that are still missing?

[Admin]

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.

1. Extract the downloaded backup (or download a fresh one without compression).
2. Open the file in a text editor (like Notepad).
3. Find the lines that begin with CREATE TABLE and USE and delete those lines. In your backup, they are lines 24 and 25.
4. Save the updated file.
5. Import the updated backup file through our phpMyAdmin.

[Oxy]

@TravelingChzhed

I hid the gdrive url because it contains your admin mail and pass

Be sure to change all that later

[TravelingChzhed]

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.

[TravelingChzhed]

Thank you!!

[Greenreader9]

Hello

Were you able to follow the instructions from Admin, or did you get lost?

If you got lost:

1. Login to your BlueHost control panel and open PHPMyAdmin
2. Select the database you would like to work with.
3. Along the top of the screen click the “Export” tab.
4. 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.
5. This will download a .sql file to your computer.
6. Open the .sql file using a text/code editor
7. Find the lines that begin with CREATE TABLE and USE and delete those lines. (Use CTRL+F to search for them)
8. Save the updated file.
9. Import the updated .sql file through our PHPMyAdmin.

[TravelingChzhed]

How would I do this on a mac? It won’t open in notepad, what are my options?

[TravelingChzhed]

What should i use to read this on a mac? I exported ok, but I don’t have a text editor that I know of. Any suggestions?

[wackyblackie]

On a Mac, you can use TextEdit, which is a built-in system application. However, you must make sure you use Plaintext mode otherwise it will save with a garbled encoding. Here’s how to do that:
https://www.iphonehacks.com/2017/06/plain-text-mode-textedit-mac.html