Scripting the initialization of a MySQL database

Question

I'm attempting to script the creation of a machine image that includes MySQL with some seed data.

I'm looking for a way to start the MySQL database engine, run a .sql script to create the data, and then shutdown the engine. Is there a best way to do this?

It looks like I could use the --init-file argument of mysqld to launch mysql and run the script, but how would I cause the database engine to shutdown after the script completes?

I'm on Ubuntu if it matters.

What if you issue mysqld shutdown immediately after?

raina77ow
– raina77ow

2013-09-28 11:54:11 +00:00
Commented Sep 28, 2013 at 11:54 — raina77ow
– raina77ow, Commented Sep 28, 2013 at 11:54

Shlomi Noach · Accepted Answer · 2013-09-28 13:22:29Z

1

Just do these three commands in one script:

service mysql start
mysql -umyuser -pmypass < /path/to/your/startup.sql
service mysql stop

You may consider using skip-networking in your /etc/mysql/my.cnf file so that the database is not accidentally accessed by anyone else for the short perios when it's up and running. In which case add the --socket argument to your mysql client command.

edited Sep 28, 2013 at 13:22

answered Sep 28, 2013 at 13:16

Shlomi Noach

9,4641 gold badge25 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Scripting the initialization of a MySQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related