Is there any way to backup/dump/export all the databases in one step and vice-versa (import all databases into MySQL) in MySQL ? If yes, then how I can do this..?
abhi10kumar
0
Junior Poster
Recommended Answers
Jump to Post
- You can use the shell command directly
- You can use a cron job to run shell or php
- Use phpMyAdmin or similar GUI
- Use php to backup etc, but AFAIK, you need to cycle through the tables.
However, I came across this: https://www.servage.net/wiki/Create_MySQL_dumps_with_PHP
…
Haven't tried it.
Jump to PostIf you use
mysqldump
, then you can use the--all-databases
parameter. Note that you should use a user which has access to them all.
All 5 Replies
diafol
toursplanet
0
Newbie Poster
techite
7
Newbie Poster
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
Purvi_1
-12
Light Poster
Banned
rproffitt
commented:
7 years late. Be timely.
-3
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.