Need Help Transfering Large Database

[artillero]

Im transfering my database to another host and it's pretty large 100mb, can someone please tell me how I can tranfer my large database to phpmyadmin.


Thank you

[jonathan184]

you will have to do it from the command line

Restoring from FILENAME.mysql is a three step process:

Drop the database

mysqladmin -u USERNAME -p drop DATABASE

Recreate the database

mysqladmin -u USERNAME -p create DATABASE

Import the backup data

mysql -u USERNAME -p DATABASE < FILENAME.mysql

[artillero]

you will have to do it from the command line

Restoring from FILENAME.mysql is a three step process:

Drop the database

mysqladmin -u USERNAME -p drop DATABASE

Recreate the database

mysqladmin -u USERNAME -p create DATABASE

Import the backup data

mysql -u USERNAME -p DATABASE < FILENAME.mysql

I want to thank you for your help, but i am pretty new to this database stuff can you please explain to me from what command line do I use to do these steps.

Thank you so much I really apreciate it.

[vpmurdan]

Hi.
1. If you are working with windows use the 'Command Prompt'.
2. Go to the 'mysql\bin' directory
3. you should see several executable files there, e.g mysql.exe, mysqldump.exe etc.
4. Now, export you database to a txt file; in the command prompt type

mysqldump -uroot -p dbname > mydb.txt

This will create a text file called mydb.txt

5. Copy the mydb.txt on your pendrive and transfer it to the computer where you want to transfer your database. copy the file in directory 'c:\temp' for follwoup with this explanation

6. Now in the new computer, go to the command prompt, go to dir 'mysql\bin'.
7. Run the mysql program, create new database, then import text file by typing:

mysql -uroot -p
create database myNewDb;
use myNewDb;
source c:\temp\mydb.txt
 

8. you have succesfully transferred your db