When you say its as though you have a brand new app is it a clean installation of satchmo, or are you getting django's congratulations it worked? When you switched from sqlite to mysql all of the data stored in the database doesn't automatically carry over. Earlier you said you tried to dump it. After dumping the data from sqlite you need to upload it into your mysql database.
-Josh On Dec 6, 11:33 am, jc <[email protected]> wrote: > Hmm, placed the above setting in local_settings.py for name, user and > password but not I have nothing on the web pages...it's as though i > have a brand new app... O.o > > On Dec 6, 1:59 pm, jc <[email protected]> wrote: > > > In my settings.py file I have > > > DATABASE_ENGINE = 'mysql' # 'postgresql', 'mysql', 'sqlite3' > > or 'ado_mssql'. > > # The following variables should be configured in your > > local_settings.py file > > DATABASE_NAME = 'mydatabasename' # Or path to database > > file if using sqlite3. > > DATABASE_USER = 'myusername' # Not used with sqlite3. > > DATABASE_PASSWORD = 'mypassword' # Not used with sqlite3. > > DATABASE_HOST = '' # Set to empty string for localhost. > > Not used with sqlite3. > > DATABASE_PORT = '' # Set to empty string for default. Not > > used with sqlite3. > > > I also went over to my local_settings.py file and changed: > > DATABASE_NAME = os.path.join(DIRNAME, 'mydatabasename.db') > > > ran python manage.py syncdb and I got: > > _mysql_exceptions.OperationalError: (1044, "Access denied for user > > 'myusername'@'localhost' to database '/home/j3/satchmo/store/ > > mydatabasename.db'") > > > j. > > > On Dec 6, 1:22 pm, "Brian O'Connor" <[email protected]> wrote: > > > > i think you're still using the database name simple.db > > > > that's generally not how it works for mysql. you usually have a server, > > > with a username and a password. > > > > On Mon, Dec 6, 2010 at 1:13 PM, jc <[email protected]> wrote: > > > > I tried to dump the sqlite data, change settings.py to use my MySQL db > > > > then run python manage.py syncdb but I keep getting this error: > > > > _mysql_exceptions.OperationalError: (1044, "Access denied for user > > > > 'username'@'localhost' to database '/home/username/satchmo/store/ > > > > simple.db'") > > > > > So I was thinking of simply using MySQL by default and bypass the > > > > migrating issue. Is this possible? > > > > > When going some of the Django tutorials, all I did was syncdb in the > > > > beginning and I've never had a problem so I'm not sure what my issue > > > > is here. > > > > > thanks again for the help, > > > > j. > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups > > > > "Satchmo users" group. > > > > To post to this group, send email to [email protected]. > > > > To unsubscribe from this group, send email to > > > > [email protected]<satchmo-users%2bunsubscr...@goog > > > > legroups.com> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/satchmo-users?hl=en. > > > > -- > > > Brian O'Connor -- You received this message because you are subscribed to the Google Groups "Satchmo users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en.
