RSH Web Services Virtual Private Server's (VPS)

• Can I access MySQL from outside my Virtual Private 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 Private Server?
A: Some customers have requested access to MySQL from outside of the Virtual Private 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 Private 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.

Please Contact Us if you have any questions concerning RSH Web Services products or services.