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
|