mysql - reload a .sql schema without restarting mysqld -


is possible reload schema file without having restart mysqld? working in 1 db in sea of many , have changes refreshed without doing cold-restart.

when "reload schema file", assume you're referring file has sql statements defining database schema? i.e. creating tables, views, stored procecures, etc.?

the solution simple - keep file sql creates tables, etc. in file, , before create statements, add delete/drop statement remove what's there. when want reload, do:

cat myschemafile.sql | mysql -u userid -p databasename 

Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -