How do I export all tables in MySQL database to .sql file using PHP?

Question

How do I export all tables in a MySQL database to a .sql file and save the file to the path I specified using PHP? I want to write a program with the functions above and execute it regularly.

Before posting a question, you should have done the proper research and made attempts to solve your issue yourself. Then, if you get stuck on something specific, come back and show us your attempt. Please read How much research effort is expected of Stack Overflow users?, How to create a Minimal, Complete, and Verifiable example and also How do I ask a good question? — M. Eriksson
– M. Eriksson, Commented Nov 21, 2018 at 6:01
I literally goggled your title and this was the 1st result on page. Looks like it should get you going in the right direction. stackoverflow.com/questions/22195493/… — Joseph_J
– Joseph_J, Commented Nov 21, 2018 at 6:05
I've tried the method provided by the URL (stackoverflow.com/questions/22195493/…). Got a fatal error: "allowed memory size of xxx bytes" and the method does not seem to provide a way to specify a path to save the file. — HSC
– HSC, Commented Nov 21, 2018 at 7:01

Justin J · Accepted Answer · 2018-11-21 07:03:19Z

0

execute the MySQL query with PHP

mysql -e "select * from myTable" -u myuser -pxxxxxxxx mydatabase > mydumpfile.txt

answered Nov 21, 2018 at 7:03

Justin J

8508 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

How do I export all tables in MySQL database to .sql file using PHP?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related