MYSQL: dump

ngaisteve1

I have a table in a database name let's say A. How do I copy and paste (database structure and data) this table to another database let's say B. B already there. I know something like dump table. But, I don't really know how. I am using mysql with control centre. Thanks.

jassh

dude..

why not checkout phpmyadmin at http://www.phpmyadmin.net/
it can create dump by structure(schema) only, data only,
or both...

it's agood tool to manage mysql databse..
i use it all the time to create database..
checkout tables.. ammend structure..

checkit out..
it's fun..
although you might have to configure something..
but hey.. what doesnt.. 🙂

this is the link...
http://www.phpmyadmin.net

hope it helps..

cheers';

-jassh

ngaisteve1

But if I am not using php?

Bunkermaster

then the next logical question is what are you doing here?

superwormy

ROFL, you could use the mysqldump command line utility to dump teh database.

Then use the mysql command line utility to load what it produces back up.

mysql -u your_username -p
[ enter your password ]

use [ the database name ]
source /the/path/to/file.sql