Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --ignore-table=view1 --ignore-table=view2 --ignore-table=view3
- SELECT CONCAT('mysqldump -u username -ppassword -h host [some options here] `',`TABLE_SCHEMA`,'` `',
- `TABLE_NAME`,'` > ',`TABLE_NAME`,'.sql') AS `sql`
- FROM `INFORMATION_SCHEMA`.`TABLES`
- WHERE `TABLE_TYPE` != 'VIEW'
- AND `TABLE_SCHEMA` NOT IN ('INFORMATION_SCHEMA', 'PERFORMANCE_SCHEMA','mysql');
- php mysqldump.php mydatabase myusername mypassword > myoutputfile.sql
- <?php
- if (is_array($argv) && count($argv)>3) {
- $database=$argv[1];
- $user=$argv[2];
- $password=$argv[3];
- }
- else {
- echo "Usage php mysqdump.php <database> <user> <password>n";
- exit;
- }
- $link = mysql_connect('localhost', $user, $password);
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- $source = mysql_select_db('$database', $link);
- $sql = "SHOW FULL TABLES IN `$database` WHERE TABLE_TYPE LIKE 'VIEW';";
- $result = mysql_query($sql);
- $views=array();
- while ($row = mysql_fetch_row($result)) {
- $views[]="--ignore-table={$database}.".$row[0];
- }
- //no views or triggers please
- system("mysqldump -u root --password="$password" $database --skip-triggers ".implode(" ",$views));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement