View Single Post

  #1 (permalink)  
Old 03-09-2006
Josselin
 
Posts: n/a
Default MySQL backup but only soem tables with a prefix

One of my friend had to mix 2 kind of tables into the same database
'friend_database' using a different prefix (pre1_tables and pre2_tables
).
He would like to backup separatly these 2 kind of tables, but using
phpmyadmin he can't (all or one by one selection.... 200 tables) Is
there any way to find a script that can do the selective backup ?
(then I'll rebuild 2 databases....)

thanks for your help

Joss

Reply With Quote