-
[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
![1TB/2TB USB 3.0 Flash Drive Thumb U Disk Memory Stick Pen PC Laptop Storage lot picture](/store/img/g/PDMAAOSwlhdmFJ5R/s-l225/1TB-2TB-USB-3-0-Flash-Drive-Thumb-U-Disk-Memory-St.jpg)
1TB/2TB USB 3.0 Flash Drive Thumb U Disk Memory Stick Pen PC Laptop Storage lot
$80.39
![Seagate ST1000VM002 1TB 64MB SATA6Gb/s 3.5](/store/img/g/tFMAAOSwjDVmceFV/s-l225/Seagate-ST1000VM002-1TB-64MB-SATA6Gb-s-3-5-Low-Pow.jpg)
Seagate ST1000VM002 1TB 64MB SATA6Gb/s 3.5" (Low Power) Hard Drive -PC, CCTV DVR
$24.99
![Type C USB 3.0 Flash Drive Thumb Drive Memory Stick for PC Laptop 1TB 2TB lot picture](/store/img/g/oroAAOSwsJNmFPcr/s-l225/Type-C-USB-3-0-Flash-Drive-Thumb-Drive-Memory-Stic.jpg)
Type C USB 3.0 Flash Drive Thumb Drive Memory Stick for PC Laptop 1TB 2TB lot
$73.29
![Fanxiang SSD 4TB 2TB 1TB PS5 SSD M.2 NVME SSD 7300MBS PCIe 4.0 Solid State Drive picture](/store/img/g/yKsAAOSwNPJlqMdQ/s-l225/Fanxiang-SSD-4TB-2TB-1TB-PS5-SSD-M-2-NVME-SSD-7300.jpg)
Fanxiang SSD 4TB 2TB 1TB PS5 SSD M.2 NVME SSD 7300MBS PCIe 4.0 Solid State Drive
$269.99
![CISCO A03-D1TBSATA 1TB 7.2K 6G 2.5INCH SATA HDD picture](/store/img/g/qqcAAOSw~xVgcyGX/s-l225/CISCO-A03-D1TBSATA-1TB-7-2K-6G-2-5INCH-SATA-HDD.jpg)
CISCO A03-D1TBSATA 1TB 7.2K 6G 2.5INCH SATA HDD
$9.00
![1TB Portable External 2.5 inch sata (Hard Drive)(random color delievery) picture](/store/img/g/F58AAOSwqsVmUAoB/s-l225/1TB-Portable-External-2-5-inch-sata-Hard-Drive-ran.jpg)
1TB Portable External 2.5 inch sata (Hard Drive)(random color delievery)
$9.99
![Patriot P210 128GB 256GB 512GB 1TB 2TB 2.5](/store/img/g/RzIAAOSwSZNlN-zB/s-l225/Patriot-P210-128GB-256GB-512GB-1TB-2TB-2-5-SATA-3-.jpg)
Patriot P210 128GB 256GB 512GB 1TB 2TB 2.5" SATA 3 6GB/s Internal SSD PC/MAC Lot
$19.99
![Samsung SSD 860 EVO 1TB 2.5 Inch SATA III Internal Solid State Drive picture](/store/img/g/PFgAAOSwbeVmhjhF/s-l225/Samsung-SSD-860-EVO-1TB-2-5-Inch-SATA-III-Internal.jpg)
Samsung SSD 860 EVO 1TB 2.5 Inch SATA III Internal Solid State Drive
$49.99
![2TB USB 3.0 Flash Drive Thumb U Disk Memory Stick Pen PC Laptop Storage US picture](/store/img/g/irQAAOSwYb1l~nVt/s-l225/2TB-USB-3-0-Flash-Drive-Thumb-U-Disk-Memory-Stick-.jpg)
2TB USB 3.0 Flash Drive Thumb U Disk Memory Stick Pen PC Laptop Storage US
$41.69
![512GB SSD 2.5](/store/img/g/4o8AAOSwA79mTOKR/s-l225/512GB-SSD-2-5-SATA-Windows-10-or-11-Preinstalled-L.jpg)
512GB SSD 2.5" SATA - Windows 10 or 11 Preinstalled - Laptop or Desktop Drive
$78.99