Is it possible to make a dump only of a table ? not the whole database.
I need to take out only the "divx" table out of the database "mystic"
DROP TABLE table_name
Hope that helps! 🙂
Unless you want to dump the data... that's another story. Here is a link:
http://www.mysql.com/doc/m/y/mysqldump.html
You can specify only a specific table.
yes I need to dump the table not delete.
I'll check out that url.
Its not clear about what has tobe done :-(
I tried : eurinfo = database divx = Table that i want a dump of.
exec("mysqldump -umyusername -pmypassword eurinfo divx > $webpathh/backup/mystic.sql");
the above works :-)