-
[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
![E5-2699V4 Intel Xeon Processor 55M Cache, 2.20 GHz SR2JS CM8066002022506 picture](/store/img/g/HmIAAOSwls5frj~X/s-l225/E5-2699V4-Intel-Xeon-Processor-55M-Cache-2-20-GHz-.jpg)
E5-2699V4 Intel Xeon Processor 55M Cache, 2.20 GHz SR2JS CM8066002022506
$155.00
![Dell Poweredge R730xd LFF 14-Bay 2U Server | Choose Your CPU & RAM Config picture](/store/img/g/CdkAAOSwY0BmYMoF/s-l225/Dell-Poweredge-R730xd-LFF-14-Bay-2U-Server-Choose-.jpg)
Dell Poweredge R730xd LFF 14-Bay 2U Server | Choose Your CPU & RAM Config
$489.99
![Dell T7810 Workstation 1x E5-2603 v3 16GB RAM Nvidia QUADRO +cables picture](/store/img/g/p7UAAOSwdWxmeBAb/s-l225/Dell-T7810-Workstation-1x-E5-2603-v3-16GB-RAM-Nvid.jpg)
Dell T7810 Workstation 1x E5-2603 v3 16GB RAM Nvidia QUADRO +cables
$120.00
![Intel Xeon E5-2699 v3 2.3GHz 18-Core 45MB 145W LGA2011-3 CPU/Processor SR1XD picture](/store/img/g/HDwAAOSwTHFl06dB/s-l225/Intel-Xeon-E5-2699-v3-2-3GHz-18-Core-45MB-145W-LGA.jpg)
Intel Xeon E5-2699 v3 2.3GHz 18-Core 45MB 145W LGA2011-3 CPU/Processor SR1XD
$40.99
![SR1XP Intel Xeon E5-2680 v3 12 Core 30MB 2.5GHz LGA 2011-3 Grade A Processor picture](/store/img/g/fEMAAOSwy1JmPnWm/s-l225/SR1XP-Intel-Xeon-E5-2680-v3-12-Core-30MB-2-5GHz-LG.jpg)
SR1XP Intel Xeon E5-2680 v3 12 Core 30MB 2.5GHz LGA 2011-3 Grade A Processor
$3.38
![Genuine Intel Xeon E5-2680V4 2.40Ghz 14-Core 35MB LGA2011 CPU P/N: SR2N7 picture](/store/img/g/fu8AAOSweXNkGJuo/s-l225/Genuine-Intel-Xeon-E5-2680V4-2-40Ghz-14-Core-35MB-.jpg)
Genuine Intel Xeon E5-2680V4 2.40Ghz 14-Core 35MB LGA2011 CPU P/N: SR2N7
$14.99
![Intel SR1XD Xeon E5-2699V3 2.30Ghz 18-Core Socket 2011 CPU Processor Haswell picture](/store/img/g/FLcAAOSwR89mfH1M/s-l225/Intel-SR1XD-Xeon-E5-2699V3-2-30Ghz-18-Core-Socket-.jpg)
Intel SR1XD Xeon E5-2699V3 2.30Ghz 18-Core Socket 2011 CPU Processor Haswell
$35.00
![Intel Xeon Gold 6140 SR3AX 2.3GHz 18-Core Processor CPU picture](/store/img/g/y6AAAOSwkWtmBd8U/s-l225/Intel-Xeon-Gold-6140-SR3AX-2-3GHz-18-Core-Processo.jpg)
Intel Xeon Gold 6140 SR3AX 2.3GHz 18-Core Processor CPU
$39.99
![1U Supermicro Server 10 Bay 2x Intel Xeon 3.3Ghz 8C 128GB RAM 240GB SSD 2x 10GBE picture](/store/img/g/7KoAAOSwephiKTf4/s-l225/1U-Supermicro-Server-10-Bay-2x-Intel-Xeon-3-3Ghz-8.jpg)
1U Supermicro Server 10 Bay 2x Intel Xeon 3.3Ghz 8C 128GB RAM 240GB SSD 2x 10GBE
$259.00
![Intel Xeon E5-2667 V4 SR2P5 (3.2GHZ/8-CORE/25MB/135W) PROCESSOR CPU picture](/store/img/g/gRcAAOSwTnpmYzzp/s-l225/Intel-Xeon-E5-2667-V4-SR2P5-3-2GHZ-8-CORE-25MB-135.jpg)
Intel Xeon E5-2667 V4 SR2P5 (3.2GHZ/8-CORE/25MB/135W) PROCESSOR CPU
$29.89