| How to export & import table using mysqldump and mysql commands - Atom8 - Jan 23, 2008 4:45am | | How-To & DIY @ Technology / Database / MySQL - Views (9662) - ( Unrated ) | This example is for Win32 MySQL server.
Using 'root' user with password as 'pass'.
Here's how to dump out the 'test' database (structure and contents) into an sql text file.
mysqldump -u root -password=pass test > testdb.sql
You can modify the contents and or structure in the SQL file above...then re-import with the usual 'mysql' command:
mysql -u root --password=pass test < testdb.sql
Last Edit: Jan 23, 2008 4:50am - by Atom8  |  |
|
| How-To & DIY | Recent Posts | | Most Viewed | How to embed Picasa Slideshow in your posts
:: VineTop - Jul 13, 2008 2:19pm
Sony PS3 250GB Upgrade on a 40GB System
:: Atom8 - Mar 03, 2008 12:58am
How to configure Apache server to run CGI scripts outside of cgi...
:: Atom8 - Jan 22, 2008 8:19pm
How to install ActiveState Perl 5.10 on Windows XP
:: Atom8 - Jan 22, 2008 5:26pm
How to embed YouTube videos in your posts
:: VineTop - Jan 19, 2008 12:52pm
How to create new post for text-only topic
:: VineTop - Jan 09, 2008 12:33am
How to install Apache web server (v2.2.x) on Windows XP
:: Atom8 - Jan 22, 2008 6:58pm
How to export & import table using mysqldump and mysql commands
:: Atom8 - Jan 23, 2008 4:45am
How to install MySQL 5.0 Server on Windows XP
:: Atom8 - Jan 22, 2008 3:32pm
ActiveState Perl 5.10 Connecting to MySQL 5.0 with Net::MySQL mo...
:: Atom8 - Jan 21, 2008 9:47pm
| | Most Commented | | Top Rated |
|
