Help fix My Database

[Veronika]

warning: max_allowed_packet might be set too low for binary map storage.
use the following query to raise max_allow_packet: set global max_allowed_packet= 16776192
running database manager
ERROR: the database you have specified in config.lua is empty, please import schemas/<engine>.sql to the database...

 

[stratzilla]

warning: max_allowed_packet might be set too low for binary map storage.
use the following query to raise max_allow_packet: set global max_allowed_packet= 16776192
running database manager
ERROR: the database you have specified in config.lua is empty, please import schemas/<engine>.sql to the database...

Not sure about the first, but the last line you mention is an improperly configured config.lua. Make sure your database exists and has pertinent tables (if it's empty, import mysql.sql or somesuch from your schema folder into your desired database, and point your config.lua to that.

Eg...

	sqlType = "mysql" //if sqlite, then put sqlite
	sqlHost = "localhost" //for most cases, keep this to localhost
	sqlPort = 3306
	sqlUser = "[B]phpMyAdmin/equivalent username goes here[/B]"
	sqlPass = "[B]phpMyAdmin/equivalent password goes here[/B]"
	sqlDatabase = "[B]sql database name goes here[/B]"
	sqlFile = "schemas/theforgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

 

[Cornex]

warning: max_allowed_packet might be set too low for binary map storage.
use the following query to raise max_allow_packet: set global max_allowed_packet= 16776192

I told you ffs, just run "set global max_allowed_packet= 16776192" in ur database..

 

[Ascendia]

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "USERNAME FOR DATABSE HERE"
sqlPass = "USER PASSWORD FOR DATABASE HERE"
sqlDatabase = "sql database name goes here"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

 

[stratzilla]

warning: max_allowed_packet might be set too low for binary map storage.
use the following query to raise max_allow_packet: set global max_allowed_packet= 16776192

I told you ffs, just run "set global max_allowed_packet= 16776192" in ur database..

How do you do this? edit; I'm an idiot.

OP, make a .php file in Notepad++ or equivalent and paste this:

<?php
	$SERVER   = "localhost";
	$USERNAME = ""; //SQL username
	$PASSWORD = ""; //SQL password
	$DATABASE = ""; //SQL database name
	$db = new PDO("mysql:dbname={$DATABASE}; host={$SERVER}", $USERNAME, $PASSWORD);
	$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
	$database = $db->query("
		set global max_allowed_packet= 16776192
	");
?>

Then open the file.

 

[Mesmeroo]

what god~ means is the following;

• Open localhost admin
• Open your database (were your server is stored)
• Go to "SQL"
• Import the following command

set global max_allowed_packet= 16776192

 

[Cornex]

He don't understand, i even post this tutorial http://otland.net/f479/mysql-how-run-query-177833/

 

[Polat Alemdar]

Try the tutorial that godiskungen posted????