Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
MySQL backup of Textpattern plugins issue
I am trying to back up my Textpattern site hosted on Textdrive. I used phpmyadmin to export the database. I used SQL and chose all the tables to export. The export runs fine and generates a valid SQL file. However upon import I get SQL errors on the table txp_plugins. No matter what I try I get the errors, usually a SQL syntax error.
Do the plugins usually export without issue? What is the procedure for backing up Textpattern complete with plugins?
The plugins I have are:
gbp_admin_library
gbp_permanent_links
ied_plugin_composer
Offline
Re: MySQL backup of Textpattern plugins issue
There’s nothing special about the plugins table… which SQL errors do you get?
Offline
Re: MySQL backup of Textpattern plugins issue
Hi I’m getting lots of errors similar to :
[ERROR in query 3] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near “\n// Constants\ndefine(“gbp_tab”,“tab”);\ndefine(“gbp_id”,“id”;\n\nc’ at line 1
Any ideas?
Offline
#4 2007-05-08 23:49:11
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: MySQL backup of Textpattern plugins issue
It sounds like something funky happened in the export. Can you post that particular query in full?
Offline
Re: MySQL backup of Textpattern plugins issue
Not sure what was up with it. I removed all the plugins, then tried an export. It worked fine. I added the plugins again the exported all seemed to work. Just one of those annoying things I guess. Thanks all.
Offline