Problems with MySql

[dogodr]

Currently we ran into some problems with the sqlite given us these error..........

12-04-04 20:50:01,ERROR,All,SQL, ExcecSQL Error: database is full in query: update ts2_clients set

12-04-04 20:50:06,ERROR,All,SQL, OpenSQL Error: database is full in query: select * from ts2_channel_privileges

After restarting the server all is well for another day.

So we have decided to move all the data to a mysql database, the dump from sqlite was successful and the Mysql DB Teamspeak with tables has been created and all info is correct.

Here is current dbexpress set up for Mysql

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=Teamspeak
Hostname=localhost
User_name=*******
Password=******
GetDriverFunc=getSQLDriverMYSQL
VendorLib=C:/mysql/lib/opt/libmySQL.dll
LibraryName=C:/Program Files/Teamspeak2_RC2/dbexpmysql.dll
Active=1


Here is the errors..........

13-04-04 16:09:03,ALL,Info,server, Server init initialized
13-04-04 16:09:03,ALL,Info,server, Server version: 2.0.20.1 Win32
13-04-04 16:09:03,ERROR,All,SQL, SQL file not found C:/Program Files/Teamspeak2_RC2/mysql_sql/read_servers.sql

This TS server is very big with 2788 registered users and 100 Channels.

1. Why is the Sqlite DB giving the "DB full' error and how would you correct that error?

2. What is missing for the Mysql DB to work?

I have noticed that in the mysql_sql file that the read_servers.sql does not exist, do I need to bring the file over from the sqlite_sql folder?

I hope you guys can help us out and thankyou!

[McAfee]

that's what I did, copied the files from the sqlite folder to the mysql folder,

but DONT replace any files that currently exist on the mysql folder.

[dogodr]

got it working.

And yes we added the sqlite_sql files to the mysql_sql folder and did not overwrite the existing files.

But this also helped too........

[DBEXPRESS]
sqldir=C:/Program Files/Teamspeak2_RC2/mysql_sql/
Drivername=mysql
Database=Teamspeak
Hostname=localhost
User_name=*******
Password=******
GetDriverFunc=getSQLDriverMYSQL
VendorLib=C:/mysql/lib/opt/libmySQL.dll
LibraryName=C:/Program Files/Teamspeak2_RC2/dbexpmysql.dll
Active=1

But question 1 still remains, why did the Sqlite DB show an error of full? Is there a limit?

[dogodr]

Update :)

Mysql was working excellent. But 7 hours after we put it in the server did a "hard crash". We have discovered that the hard drive went out. Maybe this might explain the SQlite problems we were running into.