Backing up website

hi, great plugin!
my prob....
when i Backup and Restore my database it seems to not want to back up your sql table entries in properly.
after i restore it looses member locations and wont remember the locations after updating in profile, until i uninstall and reinstall.

can you help?

this is what it feeds back after i restore my entire data base.
ps.-- this is with two members and ""34.143066","-117.279053"" being aproximent locations.
ps.-- all other tables and databases were restored fine.

-------------

Checking uploaded file...
File uploaded succesfully!

Opening file for reading...
File /tmp/php5dbeMy opened

Restoring tables, please wait...

Error:: Invalid default value for 'lat'
Attempted to CREATE TABLE e107_gmarkers (id int(11) NOT NULL auto_increment, user_id varchar(20) NOT NULL DEFAULT '', loc varchar(50) NOT NULL DEFAULT '', lat float(10,6) NOT NULL DEFAULT '', lng float(10,6) NOT NULL DEFAULT '', PRIMARY KEY (id));

Error:: Table 'smith058_db1.e107_gmarkers' doesn't exist
Attempted to INSERT INTO e107_gmarkers VALUES("1","1","Unknown location","34.143066","-117.279053");

Error:: Table 'smith058_db1.e107_gmarkers' doesn't exist
Attempted to INSERT INTO e107_gmarkers VALUES("2","2","Unknown location","33.809105","-117.921066");

Finished retoration!
Return to table list...

---------------

well i do not understand this..
while restoring e107 is running wrong query.. i mean..

CREATE TABLE e107_gmarkers (id int(11) NOT NULL auto_increment, user_id varchar(20) NOT NULL DEFAULT '', loc varchar(50) NOT NULL DEFAULT '', lat float(10,6) NOT NULL DEFAULT '', lng float(10,6) NOT NULL DEFAULT '', PRIMARY KEY (id));

where as it should be

CREATE TABLE e107_gmarkers (id int(11) NOT NULL auto_increment, user_id varchar(20) NOT NULL DEFAULT '', loc varchar(50) NOT NULL DEFAULT '',

lat float(10,6) NOT NULL, lng float(10,6) NOT NULL,

PRIMARY KEY (id));

No default value for lat and lng. In plugin.php also yo can see the query.
how you are restoring your database?

if you have the sql file backup then edit the above part of query with the correct one.

wow... i changed it and... well had a core failure. not much of a problem thanks to backups but im using the plugin "DBackup Version 1.1" from http://plugins.e107.org/e107_plugins/psilo/psilo.php?artifact.337

its most likely the way his code is for wright the database into a txt file. i noticed my ZoGo shop lost info too. so i probly wont be using the DBackup any more. although it is very simple hand handy.

its better to backup using phpmyadmin. its way too simple try it out..