Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 24-09-2009
Member
 
Join Date: Oct 2008
Posts: 116
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.
.
Reply With Quote
  #2  
Old 24-09-2009
Member
 
Join Date: Feb 2008
Posts: 31
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.
Reply With Quote
  #3  
Old 24-09-2009
Member
 
Join Date: Jan 2009
Posts: 150
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.
Reply With Quote
  #4  
Old 24-09-2009
Member
 
Join Date: Jan 2006
Posts: 181
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Connect to MySQL database on my website?"
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


All times are GMT +5.5. The time now is 04:00 AM.