dump matching tables php

Question

I'm trying to dump some of my tables if the prefix of theme is matching a given sub string using php. Trying to use php's system did not bring any result in sense the dump file was not created. I thought to use the command line function exec to achieve my result and I was making the following

 exec('E:/xampp/mysql/bin/mysqldump '. $dbname .' -h '. $this->host .' -u ' .$this->user . ' $(E:/xampp/mysql/bin/mysql -u '. $this->user . ' -p ' . $dbname .' -Bse "show tables like \'wp_dev%\'")> mydb.sql 2>&1', $output);

but to sub query what would filter out the matching tables is returning the following error

mysqldump: unknown option '-s'

It seems like I'm missing something by the syntax.

Pankaj Khairnar · Accepted Answer · 2012-12-02 12:05:36Z

2

Use like this, it will take dump of only listed tables.

exec('E:/xampp/mysql/bin/mysqldump -h '. $this->host .' -u ' .$this->user . ' -p'. $this->password .' '. $dbname .' table1 table2  > /path_to_file/dump_file.sql');

edited Dec 2, 2012 at 12:05

answered Dec 2, 2012 at 11:23

Pankaj Khairnar

3,1363 gold badges28 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

fefe Over a year ago

and how could I build in this query "show tables like \'wp_dev%\'" I would like to dump just the matching tables

fefe Over a year ago

for that I was making something like

$tables ="SHOW TABLES FROM $dbname LIKE 'wp_%'";         $result = mysql_query($tables);                       $to_dump = array();           while ($dumped_tables = mysql_fetch_row($result)) {               $to_dump[] = $dumped_tables[0];                         }

and trying to use implode. But something I'm missing by mysqldump

Pankaj Khairnar Over a year ago

check my updated solution, you have to pass tables name which you want to take backup of, you can use implode(' ', $to_dump); to form string of table names.

Collectives™ on Stack Overflow

dump matching tables php

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related