MySQL db move

Guest · Posted: Thu Feb 13, 2003 3:30 pm Post subject: MySQL db move

We need to move our Cacti installation to another server, and I am not a dba by anymeans. I can get Cacti installed correctly like new but how do I import the data so as not to corrupt anyhting. I am also assuming not to run Cacti in the Crontab untilI have the db moved- correct?

Can anyone shed some light on this?

unyks · Joined: 12 Feb 2003 Posts: 5 Location: Stuttgart/Germany

This is very simple:

1. open with your Browser PhpMyAdmin
2. select in the left frame your cacti database

your right frame shows now "Database cacti running on localhost" or anything like this on top.

3. select "Export"
4. in the "View dump (schema) of database" form select "Structure and data"
5. "Select all" (the tables in your db)
6. Select "Extended inserts" and "Save as zipped" or when you prefer "gzipped".
7. press "go"

now you have your complete db in a file downloaded..

on the new server, open phpmyadmin again

1. create a the new database with the same name from the old server
2. select "SQL"
3. point your browser to your sql-file
4. press upload

finished

i hope you understood my english, sorry

greets

chris

Guest

now how do I move the rrd files and the cacti config if the pathing is different on both servers?