How to Import My MySQL Database to Xeround Cloud Database?

Xeround provides a fully compliant MySQL database. Therefore, importing data into Xeround Cloud Database can be done using any standard MySQL functionality.

If your existing database is relatively small, you can use phpMyAdmin to load your database export file:

1. Log in to the Xeround DB Instance Manager and select the database instance you want to upload your database to
2. Click one of the ‘DNS Names’ entries in your instance’s ‘Details’ tab to open phpMyAdmin
3. Log in to your instance using your instance’s username and password
4. Click the ‘Import’ tab to browse and load your exported database.

For larger databases and in order to make the database migration faster, we recommend following the below procedure that parallelizes data import from a MySQL database.

1. First, use mysqldump to export your schema and data separately by executing the following commands:
   Exporting the schema: 

   mysqldump --net_buffer_length=4096 -–no-data --triggers  –u <user> -p<pass> -h <server> -P <port> <database> > <schema out file>

   Exporting the data:

   mysqldump --net_buffer_length=4096 --compact --no-create-info –u<user> -p<pass> -h<server> -P<port> <database> > <data out file>

   * Setting net_buffer_length to 4096 is recommended to avoid large transactions

2. Split the data export file to several smaller files in preparation for parallel loading. For example, on any Linux distribution you can use the split command:

   split –l <num of lines per file> <source file> <dest file prefix>

3. Upload yout data to Xeround database instance:
   1. Optionally, move the database export files to and do the import from a server that is as close as possible to your Xeround database instance – this will help in lowering the overall load time by minimizing network latency. For example, if your Xeround database instance resides in Amazon’s US-East datacenter in Virginia, it would be best to load your data to it from a machine in the same datacenter.
   2. Load the exported schema file – this can be achieved using the mysql command line utility in the following fashion:

      mysql  –u <user> -p<pass> -h <server> -P <port> <database>  < <schema out file>

   3. Once the schema loading completes, you can load the exported data by spawning a process for each data file. For example:

      mysql  –u <user> -p<pass> -h <server> -P <port> -D <database>  < <data out file X>