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.
