Need Help Transfering Large Database

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

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.

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
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:
8. you have succesfully transferred your db