1.1 Import Data - FusionBB Community

Username

Post: 1.1 Import Data

Dave
FusionBB Zealot
Total Posts: 8909

Location: Iola, Wisconsin
Average Post Ranks%:

12-08-06 12:22 AM - Post#38921
In response to smilesforu

If you have ssh access issue this from the command line:
mysqldump -u YourDBuserName -p YourDBname > YourDBname.sql

You'll be prompted for the db user's password.

After it's finished you can import it to your test database:

mysql -u YourTestDBuserName -p YourTestDBname < YourDBname.sql

You may want to tar/compress that sql file with:

tar cfz YourDBname.sql.tar.gz YourDBname.sql

Then download that to your computer.

Need a PHP5 - Zend Certified Engineer?
Connect with me on Linked

Edited by Dave on 12-08-06 12:25 AM. Reason for edit: ack.. tar cfz, not xfz (latter decompresses)

NOTE: You are viewing an individual Post. View the Entire Topic

Location: Main Index » Forum Index » FusionBB Pre-Sales Information » Screenshots » 1.1 Import Data » Post#38921

FusionBB™ Version 3.2 | ©2003-2013 InteractivePHP, Inc.
Execution time: 0.071 seconds. Total Queries: 42 Zlib Compression is on.
All times are (GMT-4). Current time is 07:36 AM
Top