I am trying to import my database. I went to my old database in phpMyAdmin and exported, then tried to import it in my new phpMyAdmin. I get this error

The oddest thing is that isnt the database I want. It was a differnt name.Any tips?

__________________

Do you have shell (SSH) access? May I recommend doing it that way assuming you have access?

btw...when you copy/pasted your code, you included an image from phpMyAdmin in there...so whenver somebody would view this thread, it prompted them with your cPanel user/pass in order to view that image. I fixed it, heh...it just kinda made me go "uuurrh?" when I loaded your thread.

__________________
...some super-sweet signature

Thanks for fixing that. How would I use SHH to trasfer the database? A little help I am new to this.

__________________

Well, before I spend a bunch of time explaining it, you'll need to check to see if you have access to SSH first, as many hosts do not provide it - at least not unless it is requested. SSH is not exactly easy to pick up on, because it's all command line based - but it really only takes a few commands to dump and restore a database - it's also by far the quickest and most reliable way to export/import databases.

__________________
...some super-sweet signature

Okay well I just checked out my old host and it seems they don't have it. But my new host (Site5) does. Do both hosts need to have it?

__________________

If you can export a database from the old host, that will work...Export it via phpmyadmin and then I'll let you know how to import it - is it in .sql or .sql.gz (gzipped) format?

__________________
...some super-sweet signature

Well I have tried it both ways, which one would be easiest to do it with?

__________________

gzipped, it's quicker...anyways, here's what you do.

Download PuTTY (direct link)

Export your database, gzipped, and upload it somewhere to your new server. Create a database on the new server that you will be importing to - and be sure to add a user to it.

Open PuTTY.exe and enter either the domain or IP of the new server into the first box. Click Open at the bottom. It should prompt you for a username...put the username for your new host in there. If you dunno what this is, it is listed on the NetAdmin index page for Site5. Then it will prompt you for a password...your pw for Site5 goes here...note that when you enter the password, it wont show up - that's ok, just type it and then press enter. Now you are hopefully connected.

Type 'dir' (no quotes) and press enter. This will list everything inside the folder that you're in. You want to navigate to the location that you uploaded the database. So, to go into a folder, you type 'cd foldername'...ie: If your backup is in the public_html folder, you would type 'cd public_html' and press enter. Do this until you are in the folder with your backup...to check that it's in there, type 'dir' again.

Now, type 'gunzip backupname.sql.gz' ...replace the name w/ the name of the file of course. This will decompress the db for importing. Type 'dir' and make sure that your backup is there with the .sql extension.

Now, type the following:

mysql -uusername -ppassword databasename < backupname.sql

Replace username, password, and databasename with the database information on the new server. For example...here's how your command would look with the following information.

Username: newserver_adam
Password: sshrocks
Database Name: newserver_forums
Backup File: db.sql

mysql -unewserver_adam -psshrocks newserver_forums < db.sql

Voila! Hopefully you can follow that and everything works correctly...if you get stuck somewhere, lemme know - and bookmark this, bc like I said, it is definitely the easiest and most reliable way to export/import/transfer databases.

__________________
...some super-sweet signature

Worked! Thanks Ryan you saved me from a lot of anger. Glad I asked here before I gave up. AF for life

__________________

No problem Adam - I was about excited as you are now when I learned how to do that also

Glad you got it working

__________________
...some super-sweet signature