Dumping/Modifying/Importing

[phpDan33]

Would using mysqldump to dump the database on file, modifying the contents (adding fields, data, ect), importing this same file to re-create the database be acceptable in case of an error while creating the database?

mysqldump database > file.txt
mysql < file.txt

?

[[deleted]]

More to the point: do you have any other choice? 🙂

If the database has few rows you can try to modify the database using the alter table queries, but that can seriously fragment the datafile, slowing the database down a little.