How do I migrated my database?

[Tatuy]

i buy one new host, and i need migrated my database,
i use PhpMyAdmin, look this:

 

[Infernus]

export it

 

[Tatuy]

i export all, full!! but only cant import 7 tables.. :/

 

[TKO]

no you in import all and you can export all if you are on otserv

 

[JDB]

Cykotitan,

what DB query do you execute to check if player exists?

 

[Cykotitan]

Import the tables manually 1 by 1, from the dump (.sql) file.

@JDB, this is what I use on TFS 0.2:

function playerExists(name)
	dofile("./config.lua")
	env = assert(luasql.mysql())
	con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
	local cur = assert(con:execute("SELECT `name`, `id` FROM `players` WHERE `name` = '" .. escapeString(name) .. "';"))
	local row = cur:fetch({}, "a")
	cur:close()
	con:close()
	env:close()
	return row and row.name or 0
end

 

[JDB]

@Cyko,

Using 0.3.6pl1.
Isn't there something like

db.getResult(etc)

 

[nclx]

export/import all? why need to export by parts...

JDB

docs/lua functions?...

	//db table
	db.executeQuery(query)
	db.storeQuery(query)
	db.escapeString(str)
	db.escapeBlob(s, length)
	db.stringComparisonOperator()
	db.lastInsertId()

	//result table
	result.getDataInt(resId, s)
	result.getDataLong(resId, s)
	result.getDataString(resId, s)
	result.getDataStream(resId, s, length)
	result.next(resId)
	result.free(resId)