Exporting An Importing A Table
Okay, given the issues in the post below have been resoloved, I've still got one problem:
I have a missing table on one site (the MySQL 5 issue caused the pm_events table to not install).
I have exported the pm_events table from another site. I exported as SQL.
I have changed the database name on this file to the name of the database on the site with the missing table.
Now can I just import this table into the other site that is missing the same table? I've never done this before so I'm a bit nervous about it. I'm trying to avoid running the pMachine install again.
Roo
Abhishek Reddy posted this at 20:07 — 7th February 2007.
He has: 3,348 posts
Joined: Jul 2001
When you export an individual table as SQL from phpMyAdmin, it should not contain the database name in any command. If the database name is in the file, that line ought to be commented out (comments begin with [incode]--[/incode]), and probably is by default. You shouldn't need to edit anything.
When you import an individual table, you'll be operating from the database's index page, so phpMyAdmin already knows which database you want to import into.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.