Java/Mysql help!

[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

[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

[kama3a]

for me it take from 2 to 3hours.
something is wrong but dunno where.

[SolidSnake]

for me 5 hours, I think it's normal..

[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

[macdonald12]

I'd also suggest doing it from command-line directly, as Navicat tends to slow things like that down.