• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

import mysql database fromone site to another

I have 2 sites different webhosters.

Both support mysql.

I need to import a mysql of site1 to site2

How can I do it
0
robrodp
Asked:
robrodp
1 Solution
 
Frederic SuneCEO, IT in MIND inc.Commented:
From your hosting company, you must have access to the MySQL Database trough an admin interface like PhPMyAdmin and than go to the export tab, export as SQL, select Structure and Data and Save as File...
On the new one, go to PhpMyAdmin and select the tab import and import the file your export.
Be aware if in your data you have the old url has a reference, you need to upgrade the fields with the new URL like for a migration of Wordpress to one url to another.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now