keoco Posted February 3, 2012 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 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 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 530 Reputation: 33 Joined: 01/17/12 Last Seen: August 16, 2017 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 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 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 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 530 Reputation: 33 Joined: 01/17/12 Last Seen: August 16, 2017 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 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 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 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 530 Reputation: 33 Joined: 01/17/12 Last Seen: August 16, 2017 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 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 2012 Author Share Posted February 3, 2012 yuup Quote Link to comment Share on other sites More sharing options...
Ehcloprom Posted February 4, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 82 Reputation: 11 Joined: 01/01/12 Last Seen: December 29, 2018 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 Group: Members Topic Count: 32 Topics Per Day: 0.01 Content Count: 386 Reputation: 28 Joined: 01/16/12 Last Seen: January 6, 2023 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 Group: Members Topic Count: 43 Topics Per Day: 0.01 Content Count: 130 Reputation: 0 Joined: 01/24/12 Last Seen: April 11, 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 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 707 Reputation: 168 Joined: 01/26/12 Last Seen: February 7, 2014 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...
Question
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..
Link to comment
Share on other sites
10 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.