CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 Dumping existing mySQL database to file then .....

Print topic Send  topic

Author Message
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

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.