Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TRUNCATE tableName;
- <?php
- mysql_connect('localhost', 'user', 'password');
- $dbName = "database";
- mysql_select_db($dbName)
- $result_t = mysql_query("SHOW TABLES");
- while($row = mysql_fetch_assoc($result_t))
- {
- mysql_query("TRUNCATE " . $row['Tables_in_' . $dbName]);
- }
- ?>
- mysqldump -u[USERNAME] -p[PASSWORD] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql -u[USERNAME] -p[PASSWORD] [DATABASE]
- for j in database_name1 database_name2;
- do for i in `echo 'show tables ' |mysql $j
- |grep -v 'Tables_in'`; do mysql $j -e "truncate $i"; done; done
- `echo 'show databases' | mysql | awk '$1 != "information_schema" &&
- $1 != "mysql" {if (NR > 1) {print}}'`
- for j in `echo 'show databases' | mysql |
- awk '$1 != "information_schema" && $1 !=
- "mysql" {if (NR > 1) {print}}'`; do for i in
- `echo 'show tables ' |mysql $j |grep -v
- 'Tables_in'`; do mysql -e "optimize table $j.$i";
- done; done
Add Comment
Please, Sign In to add comment