-
[mysql] how do I use it???
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
-
Senior Member
registered user
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
-
Similar Threads
-
By mzee in forum Knoppix DVD
Replies: 17
Last Post: 10-12-2005, 08:48 AM
-
By dr_rude in forum General Support
Replies: 2
Last Post: 10-11-2004, 02:37 AM
-
By sniker in forum Hdd Install / Debian / Apt
Replies: 2
Last Post: 10-08-2004, 03:50 AM
-
By Coume in forum General Support
Replies: 5
Last Post: 08-06-2003, 06:42 AM
-
By Terry@nz in forum General Support
Replies: 3
Last Post: 06-09-2003, 10:01 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
![Dell OptiPlex 3060 MICRO DESKTOP PC COMPUTER I5 8TH GEN UP TO 32GB UP TO 2TB M.2 picture](/store/img/2mYAAOSwmulmdXzA/s-l225//Dell-OptiPlex-3060-MICRO-DESKTOP-PC-COMPUTER-I5-8T.jpg)
Dell OptiPlex 3060 MICRO DESKTOP PC COMPUTER I5 8TH GEN UP TO 32GB UP TO 2TB M.2
$295.00
![New HP 24](/store/img/TWcAAOSw2QlmXTVp/s-l225//New-HP-24-All-In-One-Desktop-Computer-11th-Gen-i3-.jpg)
New HP 24" All In One Desktop Computer 11th Gen i3 Up To 32GB RAM 2TB SSD Win 11
$419.99
![Dell Latitude Business Class Laptop Quad Core i5 8th Gen 16GB 512GB SSD Grade A picture](/store/img/2qgAAOSwRo9jz~hd/s-l225//Dell-Latitude-Business-Class-Laptop-Quad-Core-i5-8.jpg)
Dell Latitude Business Class Laptop Quad Core i5 8th Gen 16GB 512GB SSD Grade A
$239.99
![HP Workstation Z640 2x Xeon E5-2623V3 32GB Ram 2x256GB SSD Quadro K420 NO OS GA picture](/store/img/rIQAAOSwN9Nlnw4a/s-l225//HP-Workstation-Z640-2x-Xeon-E5-2623V3-32GB-Ram-2x2.jpg)
HP Workstation Z640 2x Xeon E5-2623V3 32GB Ram 2x256GB SSD Quadro K420 NO OS GA
$154.98
![Intel - Core i7-13700K 13th Gen 16 cores 8 P-cores + 8 E-cores 30M Cache, 3.4... picture](/store/img/BI0AAOSw2T5jikjk/s-l225//Intel-Core-i7-13700K-13th-Gen-16-cores-8-P-cores-8.jpg)
Intel - Core i7-13700K 13th Gen 16 cores 8 P-cores + 8 E-cores 30M Cache, 3.4...
$489.99
![Intel - Core i9-13900K 13th Gen 24 cores 8 P-cores + 16 E-cores 36M Cache, 3 ... picture](/store/img/uvEAAOSwaEBjikj8/s-l225//Intel-Core-i9-13900K-13th-Gen-24-cores-8-P-cores-1.jpg)
Intel - Core i9-13900K 13th Gen 24 cores 8 P-cores + 16 E-cores 36M Cache, 3 ...
$689.99
![HP OMEN 30L Desktop Gaming PC Ryzen 7 5800X 8-Core, 16GB RAM, 1TB HD, 3060 TI picture](/store/img/2wwAAOSwrztmnaT8/s-l225//HP-OMEN-30L-Desktop-Gaming-PC-Ryzen-7-5800X-8-Core.jpg)
HP OMEN 30L Desktop Gaming PC Ryzen 7 5800X 8-Core, 16GB RAM, 1TB HD, 3060 TI
$549.99
![Intel Xeon E5-2667 V2 LGA 2011 3.3GHz 8 Core 130W 25MB 8GT/s CPU Processor picture](/store/img/rfsAAOSwEFBma4Yr/s-l225//Intel-Xeon-E5-2667-V2-LGA-2011-3-3GHz-8-Core-130W-.jpg)
Intel Xeon E5-2667 V2 LGA 2011 3.3GHz 8 Core 130W 25MB 8GT/s CPU Processor
$14.99
![TRANSOURCE MIR-B1800M | INTEL CORE I7-9700 3.00GHZ | 256GB | 16GB | NO OS picture](/store/img/R-wAAOSw-YVmmVzD/s-l225//TRANSOURCE-MIR-B1800M-INTEL-CORE-I7-9700-3-00GHZ-2.jpg)
TRANSOURCE MIR-B1800M | INTEL CORE I7-9700 3.00GHZ | 256GB | 16GB | NO OS
$159.99
![đŸ”¥Intel NUC Mini Pc Core i5, Up to 32GB RAM, 2TB SSD Windows 10 WiFi | Bluetooth picture](/store/img/KCoAAOSw6UJmkDFK/s-l225//-Intel-NUC-Mini-Pc-Core-i5-Up-to-32GB-RAM-2TB-SSD-.jpg)
đŸ”¥Intel NUC Mini Pc Core i5, Up to 32GB RAM, 2TB SSD Windows 10 WiFi | Bluetooth
$139.00