Database Export/Importing.

[batistablr]

Here is the thing, I used to use this one host that it was done alot.. it was awful. So I switched to X10Hosting. My account is up. My domain is batistablr.com. right now I am in my X10 hostings and my other Hostings Cpanel. I want to export my old database in to the x10 hosting. How would I do that. Please do step by step. like

Step 1) Click on w/e

Step 2)type w/e


Thanks in Advance,

Batistablr (Brandon Lee Roach)
Edit:
Please, Please, Please help me!!!

 

[Zenax]

Ok

Step 1.
Open up phpMyAdmin and select the database you want.

Step 2.
From there go to the export option at the top bar

Step 3.
On that page leave all the options as they are set, and press ok at the bottom. This will load a page with the SQL code on. Please not that on this step that it is actually set to SQL.

Step 4.
Copy that SQL code into a file and save it as something like table.sql (Please make sure that it has an .sql extension)

Step 5.
In your x10 account go into phpMyAdmin and select the database you want to import the tables to.

Step 6.
Now go to the Import option and then choose browse for file function. Find where you saved your file and select it. Then press Ok at the bottom and it will execute the code in the SQL file and all your tables and data will be inside that database on x10.

I hope this has helped you out a bit! Let me know if you have any problems!

Regards,
Zenax

 

[deadimp]

Explanation:
Whenever you're exporting a database using common applications such as phpMyAdmin, SQLyog, etc., they will just dump the data into a large SQL query. To import, you just execute that file.

 

[Corey]

Since there has been no response from the thread creator I am closing this thread. It may be re-opened if further assistance is needed.

-Corey