-
[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 EMC 092GD6 Broadcom 9305-16i LSI Quad Port 4 Port SAS RAID Controller picture](/store/img/g/ph8AAOSwnHxmXzcB/s-l225/Dell-EMC-092GD6-Broadcom-9305-16i-LSI-Quad-Port-4-.jpg)
Dell EMC 092GD6 Broadcom 9305-16i LSI Quad Port 4 Port SAS RAID Controller
$84.99
![OWC Guardian Maximus Raid Enclosure SATA Hard Drive FireWire picture](/store/img/g/-FoAAOSwtEBmQ5qa/s-l225/OWC-Guardian-Maximus-Raid-Enclosure-SATA-Hard-Driv.jpg)
OWC Guardian Maximus Raid Enclosure SATA Hard Drive FireWire
$36.99
![ASUS Hyper M.2 x16 Gen 4 RAID Card- Used Working picture](/store/img/g/fGwAAOSwAStmfi9c/s-l225/ASUS-Hyper-M-2-x16-Gen-4-RAID-Card-Used-Working.jpg)
ASUS Hyper M.2 x16 Gen 4 RAID Card- Used Working
$32.95
![Sans Digital 2 Bay SATA to eSATA/ USB 2.0 RAID JBOD picture](/store/img/g/v8cAAOSwd4tmeQzp/s-l225/Sans-Digital-2-Bay-SATA-to-eSATA-USB-2-0-RAID-JBOD.jpg)
Sans Digital 2 Bay SATA to eSATA/ USB 2.0 RAID JBOD
$79.35
![Dell PERC H330 PCIe 3.0 x8 RAID Storage Controller 4Y5H1 High Profile picture](/store/img/g/C7YAAOSwLYJl3nQQ/s-l225/Dell-PERC-H330-PCIe-3-0-x8-RAID-Storage-Controller.jpg)
Dell PERC H330 PCIe 3.0 x8 RAID Storage Controller 4Y5H1 High Profile
$17.99
![LSI MegaRAID 9361-8i 12Gbps PCIe 3 x8 SATA SAS 3 8 Port RAID + BBU & CacheVault picture](/store/img/g/NdcAAOSwlPtmc2X8/s-l225/LSI-MegaRAID-9361-8i-12Gbps-PCIe-3-x8-SATA-SAS-3-8.jpg)
LSI MegaRAID 9361-8i 12Gbps PCIe 3 x8 SATA SAS 3 8 Port RAID + BBU & CacheVault
$39.00
![LSI 8 Port 6Gbps PCIe 3.0 External SAS RAID Card w/ 1GB CacheVault & Low Profile picture](/store/img/g/3oUAAOSweflmcp0x/s-l225/LSI-8-Port-6Gbps-PCIe-3-0-External-SAS-RAID-Card-w.jpg)
LSI 8 Port 6Gbps PCIe 3.0 External SAS RAID Card w/ 1GB CacheVault & Low Profile
$29.00
![Inspur LSI YZCA-00424-101 Raid Card 12Gbps HBA Controller Low Profile 9300-8i IT picture](/store/img/g/25EAAOSwxzdk-ipC/s-l225/Inspur-LSI-YZCA-00424-101-Raid-Card-12Gbps-HBA-Con.jpg)
Inspur LSI YZCA-00424-101 Raid Card 12Gbps HBA Controller Low Profile 9300-8i IT
$15.98
![Yottamaster 2 Bay RAID Hard Drive Enclosure USB 3.1 For 2.5](/store/img/g/7iAAAOSwl8tlJ6Cu/s-l225/Yottamaster-2-Bay-RAID-Hard-Drive-Enclosure-USB-3-.jpg)
Yottamaster 2 Bay RAID Hard Drive Enclosure USB 3.1 For 2.5" SATA HDD SSD UASP
$56.25
![Yottamaster 5 Bay RAID Hard Drive Enclosure Type-C B For 2.5](/store/img/g/izoAAOSwfCZlZs9y/s-l225/Yottamaster-5-Bay-RAID-Hard-Drive-Enclosure-Type-C.jpg)
Yottamaster 5 Bay RAID Hard Drive Enclosure Type-C B For 2.5" 3.5" SATA HDD SSDs
$131.59