Bug!

[Ronaldino]

Hello.

I use TFS 0.2.8 (8.0), and sometimes when my computer crash and I run it again and load TFS I see that things in my console:

And then I must repair some tables... when I repair tables like 'tiles' and after 'player' or other in database it delete some players from table 'player'... wtf is that? :/

 

[ragal]

maybe u no have trigger?
when not than click here
Click Me

 

[Ronaldino]

so... how I import my tfs database?.. when without that its not possible?

 

[Mark]

That's not TFS fault, would most likely happen to anything using SQL, but try to repair the table, and also create database backups from time to time, best would be to setup a daily crontab.

 

[slaw]

@Tala

Hah, daily backup its not much I have backup per 2 hours, becouse sometimes there are really problems, like player items disappear, and houses disappear (but i'm not using latest rev)

@topic

I too have it from time to time.. I dont have any idea how to fix it- only often backup

Btw. Tala update sources plx!

 

[KaczooH]

@slawkens
How do you make out with it? How to set backup every 2hours?

 

[Ronaldino]

There is any program or something to make auto databases backups? Because I dont have any free time to make that every 2 hours ;\

btw. when I export my database I cant import it again whats happends?

 

[slaw]

btw. when I export my database I cant import it again whats happends?

Thats why i'm not using any mysql auto exporter becouse it isnt safe. I tested many another programs, but i'm using program which copy files from folder mysql/data/MYDATABASE every 2 hours.

Cobian backup.

 

[Mark]

There is any program or something to make auto databases backups? Because I dont have any free time to make that every 2 hours ;\

btw. when I export my database I cant import it again whats happends?

If you want it auto and you're using Linux, I suggest crontab to execute a shell script which runs mysqldump.

 

[Ronaldino]

In Cobian backup error:

ERR 2008-01-16 21:07:58 Error until checking for new version: Socket Error # 10061
Connection refused.

If you want it auto and you're using Linux, I suggest crontab to execute a shell script which runs mysqldump.

no, no I use Wins*it.

 

[Jonern]

I'm using the GUI tool package that MySQL offers to make backups.

http://dev.mysql.com/downloads/gui-tools/5.0.html

After you've installed (You only need the "Administrator" and the "Query Browser"), use the "MySQL Administrator" to set daily backups.

 

[KaczooH]

I'm using the GUI tool package that MySQL offers to make backups.

http://dev.mysql.com/downloads/gui-tools/5.0.html

After you've installed (You only need the "Administrator" and the "Query Browser"), use the "MySQL Administrator" to set daily backups.

I will check it What webserver (if any) are you using? Will it be compatible with XAMPP?