User avatar
johan
GpsGate
Posts: 14152
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

GUIDE: Backup and restore GpsGate Server

Sun Jul 24, 2011 8:56 pm

How to backup and restore a GpsGate Server installation

Database

Here is how to backup and restore the MySQL database
http://forum.gpsgate.com/topic.asp?TOPIC_ID=12153

Backup GpsGate Server files

GpsGate Server is typically installed under C:\GpsGateServer or under C:\Inetpub\wwwroot\GpsGateServer

Backup the following folders to an off site location

"Deploy"
"Franson NMEA Service"
"IIS"

Note that you should backup the files to some remote place.

Every time you install or update a plugin the GpsGate Server files needs to be backed up.


Restore GpsGate Server files

If you want to restore a backup on a new server. For example if you want to move to a larger server, or if your old server hard disk has crashed.

First of all restore the database as described in the link above.

Secondly restore the GpsGate Server files using the following steps:

1. Download GpsGate Server here:
http://gpsgate.com/download

2. Run GpsGateServer.exe on NEW server.

NOTE!! Cancel the Wizard when it starts!

3. Delete the following folders

C:\GpsGateInstall\GpsGateServer\Deploy
C:\GpsGateInstall\GpsGateServer\Franson NMEA Service
C:\GpsGateInstall\GpsGateServer\IIS

NOTE!! The folder is GpsGateInstall!

4. Copy your backup GpsGate Server files to C:\GpsGateInstall\GpsGateServer replacing the folders you deleted in the step above.

Now you have a new installer with the correct files!!

5. Run C:\GpsGateInstall\Install.exe on your new server.

During install selected the restored database.

Regards,
Johan

GpsGate Support

Hus
Posts: 29
Joined: Thu Jan 05, 2012 9:22 pm

RE: GUIDE: Backup and restore GpsGate Server

Mon Feb 13, 2012 8:38 pm

hi
i am stuck in somewhere restoring database as in first step
kindly note that i have canceled the installation according to instructions and then i installed mysql and created same data base name same password, i have replaced the folders according to step 4
then i tried to restore the gpsgateserver.mysqldump file
the error is:
C:\PROGRA~1\MySQL\MySQL Server 5.5\bin>mysql.exe --database mygpsgateserver -h localhost -p123456 -u root < c:\gpsgateserver.mysqldump
ERROR 1064 (42000) at line 662: 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 ''C:\\GpsGateServer\\Deploy\\DeployPackages\\com.GpsGate\\Core\\IIS\\Packages\\Gp' at line 1

C:\PROGRA~1\MySQL\MySQL Server 5.5\bin>

Hus
Posts: 29
Joined: Thu Jan 05, 2012 9:22 pm

RE: GUIDE: Backup and restore GpsGate Server

Sun Feb 19, 2012 1:28 pm

hi
the above procedure was correct 100% every thing is working perfectly now , as Johan told me via email it was database problem "database corrupted " try to make another backup .
i assumed sending the cause of the problem and the result will help others thanks for support

Job Accommodation
Posts: 72
Joined: Thu Jan 14, 2010 4:54 pm

RE: GUIDE: Backup and restore GpsGate Server

Fri Oct 05, 2012 5:12 pm

Hi Johan,

We have restored the mysql database and follow the rest of the GpsGate Server restore procedure. When we enter to the application in the server: http://localhost/GpsGateServer/VehicleT ... index.aspx and enter our username and password, we get this error:

Database error - could not fill data

How can we check the program is correctly connected to the database?

Thanks in advance!!!

User avatar
johan
GpsGate
Posts: 14152
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: GUIDE: Backup and restore GpsGate Server

Fri Oct 05, 2012 5:13 pm

Check the log files for more specific errors.

Regards,
Johan

GpsGate Support

Job Accommodation
Posts: 72
Joined: Thu Jan 14, 2010 4:54 pm

RE: GUIDE: Backup and restore GpsGate Server

Thu Oct 11, 2012 2:10 pm

Hi Johan,

Thanks for your answer and sorry for being late. In the log files we get this error:

2012-10-11 11:59:25.2500 | Error | 6 | MySQLOdbcConnector.CheckReconnect | OdbcNativeError = 0 |
2012-10-11 11:59:25.2675 | Error | 6 | DAOBase.Update | System.Data.Odbc.OdbcException | System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.1.66-community]Server does not support 4-byte encoded UTF8 characters.
en Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
en Franson.DAO.DAOBase.Update()
2012-10-11 11:59:25.2880 | Error | 6 | LoggerImpl.Write | Table sessions |
2012-10-11 11:59:25.2880 | Error | 6 | LoginControl.Login | Exception during login | Error updating database (Franson.DAO.UpdateDBException)
en Franson.DAO.DAOBase.Update()
en Franson.DAO.DAOItem.Update()
en Franson.DAO.BOItem.Update()
en Franson.Directory.AuthenticationManager.Authenticate(String strUsername, String strPassword, String strSourceAddress, User userCustom, Session sessCustom)
en Franson.Directory.AuthenticationManager.Authenticate(String strUsername, String strPassword, String strSourceAddress)
en GpsGate.WebControls.LoginControl.Login(String strUsername, String strPassword)
ERROR [HY000] [MySQL][ODBC 5.2(w) Driver][mysqld-5.1.66-community]Server does not support 4-byte encoded UTF8 characters. (System.Data.Odbc.OdbcException)
en Franson.DAO.DAOConnector.RetryConnect(Exception ex, Boolean bThrow)
en Franson.DAO.DAOBase.Update()

We have not found anything useful in Google.

Looking forward for your answer.

Thanks in advance!!!

Regards,

User avatar
johan
GpsGate
Posts: 14152
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: GUIDE: Backup and restore GpsGate Server

Thu Oct 11, 2012 2:57 pm

When I search for your error message "Server does not support 4-byte encoded UTF8 characters." on Google I get answers like:

http://stackoverflow.com/questions/1890 ... characters
http://drupal.org/node/1314214

Regards,
Johan

GpsGate Support

sene
Posts: 113
Joined: Sun Sep 08, 2013 1:58 am

RE: GUIDE: Backup and restore GpsGate Server

Sun Dec 08, 2013 6:45 am

Johan,

I have tried exactly the method describe in this guide but still i am not able to restore my database on a new server.

So i have tried by
1. Installing mysql on my new server
2. Create a database called gpsgateserver

I then run the restore script ""C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe" --database GpsGateServer -h localhost -ppassword -u root < C:\backups\GpsGateServer.mysqldump"

My dump is in the correct folder as well as the MySQL installation folder.

What am i missing?.

sene

qtech
Posts: 80
Joined: Sun Mar 17, 2013 12:19 am

RE: GUIDE: Backup and restore GpsGate Server

Sun Dec 08, 2013 3:17 pm

hello

I migrate my data from mysql administrator and has work perfectly.

piter197
Posts: 807
Joined: Sun Jan 09, 2011 3:32 am

RE: GUIDE: Backup and restore GpsGate Server

Thu Apr 23, 2015 3:23 am

Hi Support,

My previous installation was in E:\GpsServer inside it with subfolder
E:\GpsServer\Deploy
E:\GpsServer\Franson NMEA Service
E:\GpsServer\IIS

How to restore this GGS installation to drive E:\ ? (other than default C:\GpsGateInstall)

Thank you.



Best Regards,
piter197

adminlocjack
Posts: 1
Joined: Fri Aug 07, 2015 2:22 am
Location: Mexico

RE: GUIDE: Backup and restore GpsGate Server

Fri Aug 07, 2015 2:43 am

hi support

i have a error when try to install the vehicular track

An error ocurred: could not copy application. Object reference not set to an instance of object

see the error log for more details

rajiv
Posts: 104
Joined: Thu Nov 27, 2014 2:27 pm

RE: GUIDE: Backup and restore GpsGate Server

Wed Sep 02, 2015 10:05 am

Is there a guide for back and restore of MSSQL database ?

abarnard
Posts: 6
Joined: Sat May 30, 2015 12:21 am
Location: United Kingdom

RE: GUIDE: Backup and restore GpsGate Server

Wed Oct 28, 2015 5:40 pm

Hi,

Wow - that worked flawlessly, I just migrated from an old machine to a new virtual machine inside our new server.

As I followed the flow as instructed and created the database before installing GpsGateServer on the new machine I needed to install MySQL without the assistance of the Gpsgate installer.

Just in case it helps anyone else:
- The ODBC drivers need to be installed separately before GPSgate but would not install on my machine (Win7) until the Microsoft visual C++ redistributable 2010 was installed (both 32-bit and 64-bit and it needed to be 2010 not 2015 for MySQL 5.7)

regards,
Andy

rajiv
Posts: 104
Joined: Thu Nov 27, 2014 2:27 pm

RE: GUIDE: Backup and restore GpsGate Server

Mon Mar 21, 2016 10:49 am

We are planning to migrate our GPS gate to a new hosted site. This will change the current IP address of the gpsgate server will change and will involve changing the server IP addresses on devices , changing dns entry for the web site. I guess we will have to suspend NMEA services during the migration.

Can some one pl elaborate on detail migration procedure to be followed in this case ?

User avatar
johan
GpsGate
Posts: 14152
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: GUIDE: Backup and restore GpsGate Server

Mon Mar 21, 2016 3:35 pm

A simple way to migrate, where new server has same IP address:

1. Stop your original server. (This will make all devices start buffer data).

2. Make a backup + restore to new server as described in this guide:
http://forum.gpsgate.com/topic.asp?TOPIC_ID=13322

3. Check that you new server works.

4. Move new server to IP address of old server. Now all devices will start sending up buffered data.

A more advanced method to migrate, where new server has new IP address:

A useful tool for keeping the servers in sync during migration is the DataForward plugin.

DataForward the unmodified data sent from a device to one or many other servers. http://forum.gpsgate.com/topic.asp?TOPIC_ID=16118

1. Setup DataForward on your original server to send data to the new (not yet existing server).

2. Stop your original server. (This will make all devices start buffer data).

3. Make a backup + restore to new server as described in this guide:
http://forum.gpsgate.com/topic.asp?TOPIC_ID=13322

4. Check that you new server works.

5. Start your original server again. Now all devices will start sending up buffered data. And DataForward makes sure data comes to both original and new server.

6. Start migrating applications/devices to send data directly to new server.

Regards,
Johan

GpsGate Support

Return to “GpsGate Server - How to setup and use”