How to export & import table using mysqldump and mysql commands - Atom8 - Jan 23, 2008 4:45am | How-To & DIY @ Technology / Database / MySQL - Views (8507) - ( 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 | Most Commented | Top Rated | ActiveState Perl 5.10 Connecting to MySQL 5.0 with Net::MySQL mo... :: Atom8 - Jan 21, 2008 9:47pm
How to install MySQL 5.0 Server on Windows XP :: Atom8 - Jan 22, 2008 3:32pm
How to configure Apache server to run CGI scripts outside of cgi... :: Atom8 - Jan 22, 2008 8:19pm
Sony PS3 250GB Upgrade on a 40GB System :: Atom8 - Mar 03, 2008 12:58am
How to embed YouTube videos in your posts :: VineTop - Jan 19, 2008 12:52pm
How to install ActiveState Perl 5.10 on Windows XP :: Atom8 - Jan 22, 2008 5:26pm
How to install Apache web server (v2.2.x) on Windows XP :: Atom8 - Jan 22, 2008 6:58pm
How to embed Picasa Slideshow in your posts :: VineTop - Jul 13, 2008 2:19pm
How to resize your picture in Windows :: VineTop - Jan 08, 2008 1:20pm
How to upload image files to your FileBox :: VineTop - Jan 08, 2008 11:49pm
|
|