Results 1 to 4 of 4

Thread: How to Connect to MySQL database on my website?

  1. #1
    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.
    .

  2. #2
    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.

  3. #3
    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.

  4. #4
    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.

Similar Threads

  1. How to connect PHP to mySQL Database
    By Nathen in forum Tips & Tweaks
    Replies: 2
    Last Post: 17-07-2011, 03:49 AM
  2. How to speed up the MySQL database
    By Kalanidhi in forum Software Development
    Replies: 5
    Last Post: 27-02-2010, 01:33 AM
  3. Database Replication in MySQL
    By Muhammad Waqar in forum Software Development
    Replies: 5
    Last Post: 21-12-2009, 12:34 PM
  4. Replies: 3
    Last Post: 07-11-2009, 09:36 PM
  5. How to Connect MySQL database from PHP
    By Booth in forum Software Development
    Replies: 3
    Last Post: 21-01-2009, 09:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,709,359,007.64152 seconds with 17 queries