export - import MySql dbase ?
 

how can i do this ?

:helpme

mysqldump

Google it, it's easy.

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

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.

thanks a lot !! :thumbsup