Jump to content

Is there way to get tables only from sql file


rain13
 Share

Recommended Posts

Mysql file is too large to manually edit (would take weeks if not moths to get everything unnecessary out of it manually). I would like to know if there is any software that would leave only these parts that are needed to import tables. I mean my sql file has sums and selects and other code for some reason. Probably not mysql file or something. And import ends with #1193 - Unknown system variable 'Variable name'.I would like to know if there is program to filter out only what's needed to import tables.

Link to comment
Share on other sites

Guest So Called

You can do partial exports with phpMyAdmin. I've written database update utilities in PHP to edit or update an entire database or table when it was too complicated to do manually.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...