Needs a .sql File

Question

I am wondering what a .sql file looks like. How do I create one from mysqldump?

Kalium · Accepted Answer · 2009-04-03 00:51:55Z

3

mysqldump -u <user> -p <database> > out.sql

It should prompt for the password.

answered Apr 3, 2009 at 0:51

Kalium

4,6922 gold badges20 silver badges17 bronze badges

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

2 Comments

so it just looks like a text file with commands? That's simple. Thanks.

Close, but not exactly a plain text file. See marksverbiage.blogspot.com/2007/12/…