dump DB with mysql control center

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
thomasd1
Forum Commoner
Posts: 80
Joined: Sat Nov 22, 2003 2:48 pm
Location: Belgium

dump DB with mysql control center

Post by thomasd1 »

Hi,
how can i dump my database with mysql control center to a .sql file ???
:roll:
User avatar
Sevengraff
Forum Contributor
Posts: 232
Joined: Thu Apr 25, 2002 9:34 pm
Location: California USA
Contact:

Post by Sevengraff »

I don't know what you mean by mysql control center, but in phpMyAdmin you can do this:

select database
click "Export" tab
select tables to save data from
check the box "Save as file"
click "go"

then just save it as a .sql file.
User avatar
thomasd1
Forum Commoner
Posts: 80
Joined: Sat Nov 22, 2003 2:48 pm
Location: Belgium

Post by thomasd1 »

i can't find the export tab :roll:
User avatar
Sevengraff
Forum Contributor
Posts: 232
Joined: Thu Apr 25, 2002 9:34 pm
Location: California USA
Contact:

Post by Sevengraff »

If you have phpMyAdmin, you should see something like this:

Image
User avatar
scorphus
Forum Regular
Posts: 589
Joined: Fri May 09, 2003 11:53 pm
Location: Belo Horizonte, Brazil
Contact:

Post by scorphus »

thomasd1 wrote:i can't find the export tab :roll:
thomasd1, I think you - just like me :) - missed the very first line of Sevengraf's post, especially
Sevengraff wrote:(...) but in phpMyAdmin you can do this (...)
and tried to find an 'Export' tab MySQLCC.

Cheers,
Scorphus.
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Ya know older versions of phpMyAdmin didn't have that. The export tabe is pretty new thing, like only in the last year or something.
Nay
Forum Regular
Posts: 951
Joined: Fri Jun 20, 2003 11:03 am
Location: Brisbane, Australia

Post by Nay »

Yeah Pyrite, I just hate that cpanel and all have such old scripts with them =\.

-Nay
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

I prefer mysqldump command.
ptesone
Forum Newbie
Posts: 7
Joined: Mon Dec 15, 2003 11:32 am

Post by ptesone »

Hi

I execute backups easy with MySQL Turbo Manager , the options is very easy to use.

URL : http://www.mentattech.com

Regards,

Pete
User avatar
ol4pr0
Forum Regular
Posts: 926
Joined: Thu Jan 08, 2004 11:22 am
Location: ecuador

exporting

Post by ol4pr0 »

you might wanna try the

mysql-front

its a pretty easy program to use... bit unnessesary with newer versions of mysql.. however its a fun tool..


http://mysqlfront.sstienemann.de/ ( mysql front
fastfingertips
Forum Contributor
Posts: 242
Joined: Sun Dec 28, 2003 1:40 am
Contact:

Post by fastfingertips »

the mysql-front is my only MYSQL tool :). I had the luck to use this even from the beginning and in my opinion is the greatest free tool for MySQL.
Post Reply