replace:
db = DAL('sqlite://storage.sqlite')
with
db = DAL('mysql://username:password@hostname/dbname')
replace username, password, hostname and dbname with your own. That's it.
Everything is the same as with sqlite.
On Monday, 5 March 2012 09:55:10 UTC-6, Vijeenrosh PW Vijeen wrote:
>
> Hello ,
> greetings to all,
>
> Iam an new web2py user . Iam picking up the basics from the documetation
> provided there . In those only SQLite in conjuction with the DAL is
> explained .
> Unfortunately I have to use MySQL as the database.
>
> could somebody point out how to use mysql in conjuction with DAL and how
> to execute basic queries .
>
> Iam using Ubuntu 10.10 and have installed MySQL and the daemon(mysqld) is
> running .
>
> what should I do to make an connection with DAL ?
>
> ---------------------------
> Vijeenrosh PW
> www.BlackJackVijeen.blogspot.com
> Computer Science and Engineering , GEC Thrissur
> kerala, India
>
>
