export - import MySql dbase ?

[PantieZ]

how can i do this ?

[Babaganoosh]

mysqldump

Google it, it's easy.

[Varius]

Originally posted by PantieZ
how can i do this ?

Easiest method is to use mysqldump to export it. Then you can sue that file for import....example:

mysqldump -h -u -p (put your values) db_name > file.sql

mysql -h -u -p db_name < file.sql

[SinSational]

how many records?
if is is small, you can just do a dump with phpMyAdmin.

if big then easy way is just to make a php page that writes to a text file and then you can insert from that text in to the new table.

backup/restore php page.

[Babaganoosh]

Originally posted by SinSational
how many records?
if is is small, you can just do a dump with phpMyAdmin.

if big then easy way is just to make a php page that writes to a text file and then you can insert from that text in to the new table.

backup/restore php page.

That's a lot of unnecessary work. mysqldump is the correct way to do it.

[PantieZ]

Originally posted by Armed & Hammered
That's a lot of unnecessary work. mysqldump is the correct way to do it.

thanks a lot !!