MySQL Forums :: MySQL Query Browser :: export mysql database

Advanced Search

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


You can export DB in MYSQL IN Two ways.
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.

-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
export mysql database Mohd Kashif Ali Khan 10/21/2005 10:32PM
Re: export mysql database Haroon Shah 02/25/2008 11:54PM
Re: export mysql database srikanth reddy 03/10/2009 10:30PM
Re: export mysql database Jay Alverson 03/11/2009 07:55AM
Re: export mysql database mani raj 05/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.