-
[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
![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
![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
![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 Hard Disk HTS541010A9E680 HDD:5K1000-1000 1TB 2.5](/store/img/g/39YAAOSwXl1mg9Za/s-l225/1TB-Hard-Disk-HTS541010A9E680-HDD-5K1000-1000-1TB-.jpg)
1TB Hard Disk HTS541010A9E680 HDD:5K1000-1000 1TB 2.5" SATA HDD
$12.00
![1TB HDD/SSD 2.5](/store/img/g/IlgAAOSwtgpmKHfn/s-l225/1TB-HDD-SSD-2-5-SATA-Hard-Drive-for-Laptop-with-Wi.jpg)
1TB HDD/SSD 2.5" SATA Hard Drive for Laptop with Win 10/Win 11 Pro Pre-installed
$27.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
![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
![Seagate Laptop SSHD 1TB ST1000LM014 8GB NAND Flash 2.5](/store/img/g/~2cAAOSwA2hmQnyv/s-l225/Seagate-Laptop-SSHD-1TB-ST1000LM014-8GB-NAND-Flash.jpg)
Seagate Laptop SSHD 1TB ST1000LM014 8GB NAND Flash 2.5" Solid Sata Hybrid Drive
$25.99