[Help] how do i import my current sql data to a VPS?

[keoco]

how do i do that? i want to put my sql data (log,ragnarok) schemas and import them into a VPS mysql for use, hope i explained that well, thanks

*additional info : i have to upload a file, so im assuming i have to save mysql data into a file then upload it..

[ngek202]

export them first on MYSQL Workbench click Manage Import/Export.

then on phpmyadmin of your vps import them.

Edited February 3, 2012 by ngek202

[keoco]

what options do i choose in the import/export? theres log,mysql,ragnarok,test, do i have to tick them all and select tables? also i pressed "export to self-contained file"

[ngek202]

select both ragnarok and log. and 2nd option i think it says merge in one file/sql dont recall im on my cellphone right now sorry.

[keoco]

hmm it says access denied for "log".. =/

[ngek202]

when trying to import?

[keoco]

yuup

[Ehcloprom]

I blame it on that workbench crap it sucks. GUI TOOLS are easier.

[Sharpienero]

Are you using the correct password for Log?

[keoco]

i dont think i set a password for log

[Asura]

Hi keoco,

Where is your current SQL database located? And what sort of medium are you using to access it?

If you already have backed up your database into *.sql files; then just upload them onto your VPS using WinSCP. Once they are uploaded, just run this following command to import the *.sql file to your VPS's MySQL server...

mysql -u <USER> -p, --password=<PASSWORD> <DATABASE> < <FILE>.sql

Make sure your MySQL account that you are using has permissions to use that database.

Edited February 10, 2012 by Asura