in phpmyadmin i know i can export, but how can i import?

click SQL at the top and then either paste in a query or upload a .sql file

quote:

---

Originally posted by Dempsey
click SQL at the top and then either paste in a query or upload a .sql file

---

The export in phpmyadmin generates a sql query, thats how its backed up. To run the query simple find the file that has been exported then run the query. The file is saved where ever you saved it in the first place. A query can either be created then saved to a file to download or just cut and pasted.

quote:

---

Originally posted by Veggie
The export in phpmyadmin generates a sql query, thats how its backed up. To run the query simple find the file that has been exported then run the query. The file is saved where ever you saved it in the first place. A query can either be created then saved to a file to download or just cut and pasted.

---

export: select export as file and save it wherever you like (e.g your desktop for easy access)
import: select import from file and go to wherever you saved it

thats all you need to know really...

quote:

---

Originally posted by Lee Jeffery
export: select export as file and save it wherever you like (e.g your desktop for easy access)
import: select import from file and go to wherever you saved it

thats all you need to know really...

---

go to the database you want to import it into and click SQL at the top
then click browse where it says "Location of the textfile:" and click go

Note: if the file you exported was big this might take a while to import

When you export, phpmyadmin creates MySQL code which is put into a text (.txt) file. When this code is put into a MySQL command window, or in a PHP script, it will create your tables (table structure) that you exported (and insert data in them if there was any records in the table/s). So when you import, it creates the tables that you exported for backup etc.



Now to import, like Dempey said, click on the SQL image (label 1), a window will pop-up.

You can either copy the text from the exported file and past it into the area (label 2) or click on the "Import" part at the top of the window.

The area in the window will change to that of (label 3). Notice the textbox with "Browse". This, when clicked allows you to find that text file and upload it to the server. The code in the file will then be excecuted and create the tables etc.

quote:

---

Originally posted by jren207
When you export, phpmyadmin creates MySQL code which is put into a text (.txt) file. When this code is put into a MySQL command window, or in a PHP script, it will create your tables (table structure) that you exported (and insert data in them if there was any records in the table/s). So when you import, it creates the tables that you exported for backup etc.



Now to import, like Dempey said, click on the SQL image (label 1), a window will pop-up.

You can either copy the text from the exported file and past it into the area (label 2) or click on the "Import" part at the top of the window.

The area in the window will change to that of (label 3). Notice the textbox with "Browse". This, when clicked allows you to find that text file and upload it to the server. The code in the file will then be excecuted and create the tables etc.

---