Go Back   CodingForums.com > :: Server side development > Other server side languages/ issues > Python

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 12-03-2009, 08:58 PM   PM User | #1
epheterson
New Coder

 
Join Date: Nov 2007
Posts: 50
Thanks: 2
Thanked 0 Times in 0 Posts
epheterson is an unknown quantity at this point
Question Re-sync MYSQL database for Python-Based Django Site

Hey, I'm cross-posting this from the MYSQL forum because I'm not exactly sure which type of programmer would better help me.

I'm an IT guy who found myself editing a Django site created atop Python. I've made a change and now need to re-sync with the database. I have a file the previous IT guy left me with instructions:

Quote:
python manage.py dbshell
-This opens a shell to the database. It should say “mysql>” before the cursor now

DUMP SCHEMA cipps;
CREATE SCHEMA cipps;
exit
When I type "DUMP SCHEMA cipps;" I get an error:
Quote:
ERROR 1064 (42000): You have an error in your SQL syntax ...
Could you please help me find the correct syntax to do what I'm attempting? I'm note entirely sure what the command is supposed to do even, but I believe it dumps the contents of SCHEMA (likely tables without data) to a file called cipps, then CREATE re-creates the structure using the file DUMP created.

Thanks

Last edited by epheterson; 12-03-2009 at 09:27 PM..
epheterson is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 11:21 PM.


Advertisement
Log in to turn off these ads.