What's the standard way to wipe out every info in the database but keeps the
schema?
What I do now is to dump the database without data to a file, then drop the
database, then create it, then load it back from the file. (just learned
from this mailing list)
$mysqldump --no-data --password --host=server_name1 db_name > file_full_path
$mysqladmin --password --host=server_name1 --force drop db_name
$mysqladmin --password --host=server_name1 create db_name
$mysql --password --host=server_name1 db_name < file_full_path
Are there alternative? and what's the 'proper' way?
Thanks.
Xah
xah@stripped
http://www.best.com/~xah/PageTwo_dir/more.html
"Windoz: a monstrous hack of greed;
unix: a monstrous hack of stupidity;
GNU: stamps out greed, stamps out stupidity."
