Member Avatar for riahc3

Hey

I want to make a backup and restore of a MySQL SERVER to another machine. Please note the SERVER part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....EVERYTHING

What is the best way to do this? Thank you

  • 5 Contributors
  • 6 Replies
  • 233 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by Manish02
Member Avatar for pritaeas

You can use mysqldump to export everything to an sql script file. On the other server you can use mysql to import it again. Both are command line tools. Note that users are never exported, you will have to recreate these manually.

Edited by pritaeas
Member Avatar for smantscheff

You can export the system database (users, rights etc.) with mysqldump mysql and import it again, but this may lead to all sort of trouble.

Member Avatar for riahc3

Note that users are never exported, you will have to recreate these manually.

No way to do this? Third party tool?

Member Avatar for smantscheff

What you can do:
Identify all tables in the database mysql which have a field called User. Export those tables with mysqldump. Feed them into the new database. Make sure that you run mysql with admin privileges (usually as user root). Restart the mysql server with the new database after the import. And hope for the best.

Member Avatar for sathish_nadu

I use SQLyog for this where we can connect to the remote server and take a back up with this tool.

Member Avatar for Manish02

i think SQLYOg is best option for him

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.