Joe
|
| Posted: 03/02/2002, 1:34 PM |
|
I am trying to dump an existing mySQL database from my hosting company server and then load it locally so I can use it in CC. Here's the steps that I have followed... What am I doing wrong?
mysqldump -uUSERNAME -pPASSWORD datasename > database.sql
Then I tried to import using mySQL frontend for windows but it won't work!
Is that the wrong way to get a copy of my database from my server?
Can anyone help me?
Joe
|
|
|
 |
feha
|
| Posted: 03/02/2002, 3:15 PM |
|
You should use phpMyAdmin-2.2.3 on Your server(they have it...)
Dump the database WITH CONTENTS...
Then copy MySQL script and paste it to MySQLFront in the field for SQL query...
( a nice program) and press 'play' button...
Regards
feha
www.vision.to/cgi
|
|
|
 |
thomas
|
| Posted: 03/03/2002, 1:28 AM |
|
the easiest way is:
mysql -uUSERNAME -pPASSWORD databasename < database.sql
Be sure that database.sql is in your local path ...
thomas
|
|
|
 |