Skip navigation links

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


Advanced Search

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
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.