MySQL Forums
Forum List  »  MySQL Query Browser

Re: export mysql database
Posted by: Haroon Shah
Date: February 25, 2008 11:54PM

Hello,

You can export DB in MYSQL IN Two ways.
1. Command line
2. Using PHPMYADMIN.

1. COMMAND LINE.
In command line you can back up your database using one of the following technique.
mysql> mysqldump DBname [table names];

[table names]-> your tables that u want to back up.

2.
-Open phpmyadmin
-select your DB
-select Export from top menu
-select all tables from side List.
-Check the checkbox that label "Save file as"
-click the Go button to save your DB; with all the records been saved as well.

Have fun ;)

Options: ReplyQuote


Subject
Written By
Posted
October 21, 2005 10:32PM
Re: export mysql database
February 25, 2008 11:54PM
March 10, 2009 10:30PM
March 11, 2009 07:55AM
May 17, 2009 01:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.