Teach you the Database migration "illustrated"

Source: Internet
Author: User

Tools: excel,mysql,navicate, Cloud Database ...

First of all, we are using Baidu's cloud database, so my task now is to move the cloud database data to the local database above! Because of the field is not unified, and I still novice or a lot of time before the whole good, I hope to help everyone! At the same time, I also gained a lot of ...

First enter our cloud database, this is our user_system_info table

Then click the Export button:

Then click the Execute button, this will automatically generate TXT file, and then start to convert the TXT file into Excel format it!

Then click the Import Data button,

Choose the encoding format, this must be selected correctly!

Then step by step operation, OK!

Then open a see TXT file data has been in accordance with our format on the line layout!

The following is the import of Excel data into our database.

The first thing you can see is that the data inside our database is a null value

Click the Import Wizard to select the Excel file.

Then the data according to the "|" Separated

Then we'll see that the Excel data has been delimited.

You can select a table as a pre-selection,

Then Navicate did a very good thing, is can automatically match the field, which can save me a lot of time!

Then just wait and it's OK. About 1, 2 seconds.

At this point, all the work is done!


Maybe this is not the best way, but it is also a good solution, hoping to be good for everyone .....

Teach you the Database migration "illustrated"

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.