MySQL and SQL

[K4stic]

Hello Community

i wonna ask and to you show me how to transfer data of SQL to MySQL

MySQL

dbExec( connection, "INSERT INTO accounts SET username=?, password=?, serial=?", string.lower( user ), sha256( pass ), getPlayerSerial( source )) 

[Castillo]

I don't understand what do you want to do.

[K4stic]

i make this:

addEventHandler("onResourceStart", resourceRoot, 
function () 
    local playersacc = executeSQLQuery( "SELECT id, name, password, serial FROM accounts",idName, nameName, passwordName, serialName ) 
        for i, playerdata in ipairs(playersacc) do 
            dbExec( connection,"INSERT INTO accounts SET id=?,username=?, password=?, serial=?", playerdata.id, playerdata.name, playerdata.password, playerdata.serial ) 
        end 
    end 
) 

but it say no exist table accounts(and the table accounts is on internal.db)

i wonna transfer account Data's from internal.db(id,username,password,serial) to MySQL

[Castillo]

That's because executeSQLQuery uses the "registry.db" database.

[K4stic]

thanks for that info so how i can make it :3

[Castillo]

You can't really make it, since you can't get the password with scripts, you must convert the table with some program to a mysql table, then import it.

[fmj02]

Search for sqlite to mysql converter with google.

List of converter tools:

http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

Edited May 30, 2013 by Guest

[K4stic]

i find better

http://www.spectralcore.com/fullconvert/