Customer Reviews

Read More

The World's Leader in Virtual Server Technology

• Can I access MySQL from outside my virtual server?
• I currently use mSQL but want to switch to MySQL. How do I move my databases over?

Q: Can I access MySQL from outside my virtual server?
A: Some customers have requested access to MySQL from outside of the virtual server using Java JDBC or Window ODBC. However, this is not possible. For security reasons, TCP/IP connections to MySQL have been disabled.

Q: I currently use mSQL but want to switch to MySQL. How do I move my databases over?
A: First, run the following command at your virtual server's SSH prompt, where database is the name of the database to export, and table is the table within the database you are exporting:
msql2export database table > table.txt
Then, run the following command to import the database into MySQL:
mysqlimport --fields-terminated-by=',' database table.txt
This will create the table "table" in your MySQL database.