Printable View
hi,
I am developping my website in php under linux but I need to connect to a mysql db...
It seems I have to copy my db in /etc/lib/mysql/ but how can I access them from my test webpage and what do I need to run to get them working??
Thxs in advance
Ludo
The MySQL part is the hardest part. You really need to go to the MySQL site and download the manual. Really. It's very good.
If you do a Google for
MySQL php
you should find lots of tutorials. Don't expect this to be easy (but it's not rocket science, either).
It's difficult to say anything without knowing more details. But one thing to watch out for is the case in Database/Table names. If you copied your db over from Windows (which is case-insensitive) sometimes files names are incorrect on Linux (which is case-sensitive). The correct names for the files are tablename.frm, tablename.MYD, tablename.MYI. Also check the permissions.
If you are working on something that did work in another environment check mysql_error(). If you are starting from the beginning I'll second fingers99: there is lot's of good tutorials out there and the official PHP and MySql manuals are really very good.
- - Edwin
thxs :)
I'll go to the MySQL website and print a nice documentation from work to read it at home :)
eheh
Ludo
P.S: I really start to like Linux... :)