Vinetop
 
{ Guest } - Login Browse 
:: Browse Topic Focus
Journal
General
How-To & DIY
Tips & Tricks
Reviews
 

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        Comments | Report




Comments and Ratings:( Post Your Comments )

No Comments...

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

© 2007 - 3000 vinetop.com [ Terms & Policy :: Contact Us :: About ]