Hi all and thanks so much for the feedback. I did finally figure how to migrate over to MySQL. After I got a few things straight on my end it really is fairly easy. Unfortunately, MSQL complained of Integrity Errors..etc..and I'm at a loss of how to fix that issue. In fact, this site is small enough where I can simply start a new project and immediately migrate over to MySQL and start from there. Of course, this route now introduces more of a Satchmo-related question that I'll ask on a new thread.
Thanks for the feedback, I've made notes from the info you've gave me. J. On Dec 6, 1:41 pm, Josh Cartmell <[email protected]> wrote: > Basically your database setting should look something like this > (depending on what version of django you are using, more recent ones > have a slightly new syntax but still essentially the same): > DATABASE_ENGINE = 'mysql' # 'postgresql', 'mysql', 'sqlite3' > or 'ado_mssql'. > # The following variables should be configured in your > local_settings.py file > DATABASE_NAME = 'name_of_mysql_database' # Or path to > database file if using sqlite3. > DATABASE_USER = 'mysql_username' # Not used with sqlite3. > DATABASE_PASSWORD = 'mysql_username_password' # Not used with > sqlite3. > DATABASE_HOST = '' # Set to empty string for localhost. > Not used with sqlite3. > DATABASE_PORT = '' # Leave blank for default/standard > settings > > You have to create a database in mysql (generally this can be done > through some sort of web interface but it also is possible to do it at > the command line) and a user who has access to the database. > Sqlite is a database in a file, in this case simple.db, mysql on the > other hand relies no a mysql database server. Generally it is easy to > create mysql databases through most hosts. > > -Josh > > On Dec 6, 10:22 am, "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.
