Page 2 of 2
Re: Java/Mysql help!
Posted: Fri Sep 10, 2010 1:15 pm
by Gnacik
mainly import time depends how you create export. if you have fu...cked up export files (for example insert statement for every row) can take few hours. with correctly done export, import take a maybe minute only, even for big server's
Re: Java/Mysql help!
Posted: Fri Sep 10, 2010 2:52 pm
by badboy29
ATM my players with good connection not have any lags, so I think everything is ok, in future only have to increase memory
PS: for dump database i use this script from *fork* guide:
sqlbackup.sh
Code: Select all
#!/bin/bash# Server backup. This script will check MySQL data integrity and create a backup from it.# Cyberfox - [email protected]# SQL check - mysqlcheck --help for full details / tweaksmysqlcheck -A -a -c -e -r -o -s -u youruser -pyourpass --auto-repair# Backupmysqldump --databases yourdatabase --user=youruser --password=yourpass > /home/l2j/backup/backup.weekly.backup_`date '+%d%b%y_%H%M'`.sql
Only a few minutes to import (database 388MB)
Code: Select all
mysql -h localhost -u youruser -pyourpass yourdatabase < yourSQLFile.sql
Re: Java/Mysql help!
Posted: Fri Sep 10, 2010 6:26 pm
by kama3a
for me it take from 2 to 3hours.
something is wrong but dunno where.
Re: Java/Mysql help!
Posted: Fri Sep 10, 2010 7:20 pm
by SolidSnake
for me 5 hours, I think it's normal..
Re: Java/Mysql help!
Posted: Thu Sep 16, 2010 11:57 pm
by UnAfraid
haha what a hours last time when i move servers from one pc to another i did it for 30 mins .. (with installing all need apps and config..)
Gnat answer u very correctly read what it wrotte
Re: Java/Mysql help!
Posted: Fri Sep 17, 2010 3:19 pm
by macdonald12
I'd also suggest doing it from command-line directly, as Navicat tends to slow things like that down.