Import Database to New Server
-
Server
- FOG Version: 1.3.5
- OS: Ubuntu 16.04 LTS
I have been forced to migrate to a new server. I exported my database to the fogbackup.sql per the Wiki. Now when I try to import it using mysql -D fog -u root -p < backup_path.sql I get a lot of syntax errors. I have tried researching imports using mysql without any luck. Anyone here have any suggestions? Below is what I am trying and what the output is
mysql -D fog -u root -p < /home/fogadmin/fogbackup.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databa’ at line 1 -
I found in the GUI that did exactly what I needed. Since I am now on a server with more storage than the old server how do I get the Web Console on the new server to see the new server’s larger storage capacity?
Thanks,
Anthony
-
What version did you upgrade from?
The Web gui should see right away the current storage size. What do you get when you open a linux console prompt and key in
df -h? -
@george1421 I get 8.3TB–which is what I would expect.
-
@george1421 I realized my mistake. I had to change the IP Address of the storage group to the new IP of the new server. Sorry my bad on that one.
-
@atarone solved then?? (just to keep things tidy).
-
This article covers every aspect of FOG Server migration: https://wiki.fogproject.org/wiki/index.php?title=Migrate_FOG
-
@george1421 yes this has been solved. Sorry for the delay I have been out the last few days