Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
thomasd1
- Forum Commoner
- Posts: 80
- Joined: Sat Nov 22, 2003 2:48 pm
- Location: Belgium
Post
by thomasd1 »
Hi,
how can i dump my database with mysql control center to a .sql file ???

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

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

-
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

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.
-
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
-
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
-
ol4pr0
- Forum Regular
- Posts: 926
- Joined: Thu Jan 08, 2004 11:22 am
- Location: ecuador
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.