-
[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
![IBM System X3250 M3 Server 8GB RAM Intel Xeon x3440 2.53ghz (NO HDD) picture](/store/img/g/M~sAAOSwFVlkVr-r/s-l225/IBM-System-X3250-M3-Server-8GB-RAM-Intel-Xeon-x344.jpg)
IBM System X3250 M3 Server 8GB RAM Intel Xeon x3440 2.53ghz (NO HDD)
$41.99
![IBM x3250 M4 1U Server With Four 2.5](/store/img/g/vZsAAOSwPOdmctvy/s-l225/IBM-x3250-M4-1U-Server-With-Four-2-5-Drive-Bays.jpg)
IBM x3250 M4 1U Server With Four 2.5" Drive Bays
$299.99
![IBM Power S822 8284-22A 12SFF Power8 3.89GHz 6Core 64GB RAM No HDD Server System picture](/store/img/g/xiEAAOSwwGtmRmN6/s-l225/IBM-Power-S822-8284-22A-12SFF-Power8-3-89GHz-6Core.jpg)
IBM Power S822 8284-22A 12SFF Power8 3.89GHz 6Core 64GB RAM No HDD Server System
$359.99
![IBM Server System X3100 M4 | Xeon @ 3.10 Ghz | 8GB | 250GB HDD No OS (IG-PC26) picture](/store/img/g/vCUAAOSwSJhlCJV3/s-l225/IBM-Server-System-X3100-M4-Xeon-3-10-Ghz-8GB-250GB.jpg)
IBM Server System X3100 M4 | Xeon @ 3.10 Ghz | 8GB | 250GB HDD No OS (IG-PC26)
$96.01
![IBM x3650 M4 Server Intel Xeon E5-2640 (x2) 144GB RAM No HDDs (#4XN7N) picture](/store/img/g/~~AAAOSwFFZmeyKv/s-l225/IBM-x3650-M4-Server-Intel-Xeon-E5-2640-x2-144GB-RA.jpg)
IBM x3650 M4 Server Intel Xeon E5-2640 (x2) 144GB RAM No HDDs (#4XN7N)
$199.99
![IBM System x3550 M3 Dual Intel Xeon X5650 @2.67GHz 32GB RAM No HDD picture](/store/img/g/oRsAAOSw~pRmQitC/s-l225/IBM-System-x3550-M3-Dual-Intel-Xeon-X5650-2-67GHz-.jpg)
IBM System x3550 M3 Dual Intel Xeon X5650 @2.67GHz 32GB RAM No HDD
$68.50
![ibm server z series picture](/store/img/g/RKAAAOSw365hbg9L/s-l225/ibm-server-z-series.jpg)
ibm server z series
$16000.00
![IBM 7914-AC1 V2 X3550 M4 SERVER V2 picture](/store/img/g/rFgAAOSwsmNmcKtS/s-l225/IBM-7914-AC1-V2-X3550-M4-SERVER-V2.jpg)
IBM 7914-AC1 V2 X3550 M4 SERVER V2
$194.99
![1U IBM x3550 M5 4 Bay SFF SAS3 Server 2x E5-2683 V3 28 Core 128GB DDR4 2x Tray picture](/store/img/g/RRoAAOSwonVguq4o/s-l225/1U-IBM-x3550-M5-4-Bay-SFF-SAS3-Server-2x-E5-2683-V.jpg)
1U IBM x3550 M5 4 Bay SFF SAS3 Server 2x E5-2683 V3 28 Core 128GB DDR4 2x Tray
$318.00
![IBM x3650 M4 2x Xeon E5-2670 2.6ghz 16-Core / 64GB / M5110e / 2x PSU picture](/store/img/g/YXgAAOSwzGNjh6tH/s-l225/IBM-x3650-M4-2x-Xeon-E5-2670-2-6ghz-16-Core-64GB-M.jpg)
IBM x3650 M4 2x Xeon E5-2670 2.6ghz 16-Core / 64GB / M5110e / 2x PSU
$229.99