keoco Posted February 3, 2012 Share Posted February 3, 2012 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.. Quote Link to comment Share on other sites More sharing options...
ngek202 Posted February 3, 2012 Share Posted February 3, 2012 (edited) export them first on MYSQL Workbench click Manage Import/Export. then on phpmyadmin of your vps import them. Edited February 3, 2012 by ngek202 Quote Link to comment Share on other sites More sharing options...
keoco Posted February 3, 2012 Author Share Posted February 3, 2012 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" Quote Link to comment Share on other sites More sharing options...
ngek202 Posted February 3, 2012 Share Posted February 3, 2012 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. Quote Link to comment Share on other sites More sharing options...
keoco Posted February 3, 2012 Author Share Posted February 3, 2012 hmm it says access denied for "log".. =/ Quote Link to comment Share on other sites More sharing options...
ngek202 Posted February 3, 2012 Share Posted February 3, 2012 when trying to import? Quote Link to comment Share on other sites More sharing options...
keoco Posted February 3, 2012 Author Share Posted February 3, 2012 yuup Quote Link to comment Share on other sites More sharing options...
Ehcloprom Posted February 4, 2012 Share Posted February 4, 2012 · Hidden by Ehcloprom, February 4, 2012 - bleh useless to the topic Hidden by Ehcloprom, February 4, 2012 - bleh useless to the topic I blame it on that workbench crap it sucks. GUI TOOLS are easier. Link to comment
Sharpienero Posted February 4, 2012 Share Posted February 4, 2012 Are you using the correct password for Log? Quote Link to comment Share on other sites More sharing options...
keoco Posted February 4, 2012 Author Share Posted February 4, 2012 i dont think i set a password for log Quote Link to comment Share on other sites More sharing options...
Asura Posted February 10, 2012 Share Posted February 10, 2012 (edited) 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 1 Quote Link to comment Share on other sites More sharing options...
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..
Link to comment
Share on other sites