-
[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
![Samsung 16GB 1Rx8 DDR5 5600MHz EC8 RDIMM PC5-44800 Memory RAM (M321R2GA3PB0-CWM) picture](/store/img/g/hTkAAOSwFb5mIuVF/s-l225/Samsung-16GB-1Rx8-DDR5-5600MHz-EC8-RDIMM-PC5-44800.jpg)
Samsung 16GB 1Rx8 DDR5 5600MHz EC8 RDIMM PC5-44800 Memory RAM (M321R2GA3PB0-CWM)
$99.99
![A-Tech 8GB DDR3 1600 PC3-12800 Laptop SODIMM 204-Pin Memory RAM PC3L DDR3L 1x 8G picture](/store/img/g/RCAAAOSweqdeWaui/s-l225/A-Tech-8GB-DDR3-1600-PC3-12800-Laptop-SODIMM-204-P.jpg)
A-Tech 8GB DDR3 1600 PC3-12800 Laptop SODIMM 204-Pin Memory RAM PC3L DDR3L 1x 8G
$13.99
![8GB PC3L-12800S 1600MHz SODIMM DDR3 RAM | Grade A picture](/store/img/g/tmAAAOSwxu1mDNSQ/s-l225/8GB-PC3L-12800S-1600MHz-SODIMM-DDR3-RAM-Grade-A.jpg)
8GB PC3L-12800S 1600MHz SODIMM DDR3 RAM | Grade A
$12.00
![Crucial DDR3L 16GB 1600 2x 8GB PC3-12800 Laptop SODIMM Memory RAM PC3 16G DDR3 picture](/store/img/g/mecAAOSw2Vlkv6Ot/s-l225/Crucial-DDR3L-16GB-1600-2x-8GB-PC3-12800-Laptop-SO.jpg)
Crucial DDR3L 16GB 1600 2x 8GB PC3-12800 Laptop SODIMM Memory RAM PC3 16G DDR3
$22.45
![Team T-FORCE VULCAN Z 32GB (2 x 16GB) PC RAM DDR4 3200 (PC4 25600) Memory picture](/store/img/g/~u4AAOSwK-liKn7t/s-l225/Team-T-FORCE-VULCAN-Z-32GB-2-x-16GB-PC-RAM-DDR4-32.jpg)
Team T-FORCE VULCAN Z 32GB (2 x 16GB) PC RAM DDR4 3200 (PC4 25600) Memory
$54.99
![Team T-FORCE VULCAN Z 16GB (2 x 8GB) 288-Pin PC RAM DDR4 3200 (PC4 25600) Intel picture](/store/img/g/uPEAAOSw0-1mBgnN/s-l225/Team-T-FORCE-VULCAN-Z-16GB-2-x-8GB-288-Pin-PC-RAM-.jpg)
Team T-FORCE VULCAN Z 16GB (2 x 8GB) 288-Pin PC RAM DDR4 3200 (PC4 25600) Intel
$33.99
![HyperX FURY DDR3 8GB 16GB 32GB 1600 MHz PC3-12800 Desktop RAM Memory DIMM 240pin picture](/store/img/g/XNYAAOSwg81kv6CG/s-l225/HyperX-FURY-DDR3-8GB-16GB-32GB-1600-MHz-PC3-12800-.jpg)
HyperX FURY DDR3 8GB 16GB 32GB 1600 MHz PC3-12800 Desktop RAM Memory DIMM 240pin
$15.90
![Kingston HyperX FURY DDR3 8GB 16GB 32G 1600 1866 1333 Desktop Memory RAM DIMM picture](/store/img/g/DWUAAOSw5e1kv6CT/s-l225/Kingston-HyperX-FURY-DDR3-8GB-16GB-32G-1600-1866-1.jpg)
Kingston HyperX FURY DDR3 8GB 16GB 32G 1600 1866 1333 Desktop Memory RAM DIMM
$38.95
![HP EliteBook 840 G10 14 WUXGA Intel Core i5-1335U 16GB RAM 512GB SSD Notebook S picture](/store/img/g/oecAAOSwWqlmVoBf/s-l225/HP-EliteBook-840-G10-14-WUXGA-Intel-Core-i5-1335U-.jpg)
HP EliteBook 840 G10 14 WUXGA Intel Core i5-1335U 16GB RAM 512GB SSD Notebook S
$599.99
![64GB (4X 16GB) DDR3-1333 PC3-10600 Memory RAM for APPLE MAC PRO 5,1 Westmere picture](/store/img/g/f-IAAOSwUGxlwZ7W/s-l225/64GB-4X-16GB-DDR3-1333-PC3-10600-Memory-RAM-for-AP.jpg)
64GB (4X 16GB) DDR3-1333 PC3-10600 Memory RAM for APPLE MAC PRO 5,1 Westmere
$49.99