|
|
![]() |
| Thread Tools | Search this Thread |
#1
| |||
| |||
How to Connect to MySQL database on my website? I need to connect my site to a mysql database with some php code. Is there any advice out there that could assist me? The reason is because, we all know that database is very improtant if we have dynamic website. . |
#2
| |||
| |||
Re: How to Connect to MySQL database on my website? You can periodically keep deleting the binary logs, as they keep on being generated and eat up ur disk space. You should learn to debug "on-line", that is, add displayed infos in case something goes wrong, or a not to say it went ok, so when you have an error, you can find out where it comes from your code! The thread that fetches the logs, maintains a persistent connection - which means, as soon as the master generates a log, it's pulled out by the slave. |
#3
| |||
| |||
Re: How to Connect to MySQL database on my website? You need to have mysql / php running on the server, then you need to write bits of php to access the database and generate the appropriate html output. The Slave's run TWO threads - one which keeps fetching these Binary logs down to the Slave, and another thread, which acts upon the logs, figures out what changes have been made and immediately updates its own databases with the changes pulled out from the master. |
#4
| |||
| |||
Re: How to Connect to MySQL database on my website? If you log onto Macromedia home page and search for tutorials on ASP, there are absolutely loads of them. To access a remote UNIX server from a personal computer, you'll need a software application called a "terminal emulator". A terminal emulator opens a window into which you can type command lines to do stuff on the UNIX server. I have been down a similar road but chose to use PHP, there are far more ASP tutorials than PHP ones available. |
![]() |
|
Tags: mysql database, php code, website |
Thread Tools | Search this Thread |
|
![]() | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to connect PHP to mySQL Database | Nathen | Tips & Tweaks | 2 | 17-07-2011 03:49 AM |
How to speed up the MySQL database | Kalanidhi | Software Development | 5 | 27-02-2010 01:33 AM |
Database Replication in MySQL | Muhammad Waqar | Software Development | 5 | 21-12-2009 12:34 PM |
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 | roshan45 | Software Development | 3 | 07-11-2009 09:36 PM |
How to Connect MySQL database from PHP | Booth | Software Development | 3 | 21-01-2009 09:12 PM |