You are here: Home » M » My » Mysql

Mysql

Posts tagged with Mysql

Best Free Web Statistics and Analytics Packages For Sites Using PHP & MySQL.
I'm looking for a list of the best free web statistics and analytics packages for my my site using PHP & MySQL?...

Any suggestion on MySQL services?
I would like to separate my production server into 2, one for running code, the other one is for DB, which is MySQL.Is there any suggestion if I would like to subscribe a MySQL service? I have few applications need such standalone database service. So I would like to a service which allo...

Change of mysql db password brings down website
Hello,Each time I change the MySQL db password, and update the dbconfig file, the website is down.I also flush privilegesAny idea why?...

ASP.NET, PHP, SQL Server, MySQL hosting provider for developer?
I am looking to find a web hosting provider that provides ASP.NET and PHP hosting. The purpose is pretty much just a programming playground for me to develop in and possible show some of my work.As I use ASP.NET and PHP I am looking for a provider that provides hosting for both of these ...

large/huge example databases .sql files to download on the web?
Where can i find really large databases .sql files with 100's MB or a few GB text, 10.000.000 plus rows of text so I can test my sphinx search engine indexing...

How to using ajax for voting script.
I'm trying to set up some voting logic on my site, and have the vote result update without refreshing the site. I did some research and AJAX seems to be the way to go, but i cant find a good tutorial on it.im doing the update to Mysql $query = "update RR_upload set vote ...

How to create separate users in phpmyadmin, each one can't see others databases?
I am using phpmyadmin to control mysql on my server, now i want to create some users to access this admin tool, what i want is to make each user can create databases but can't see others databases.Is that possible and how?...

Open Source website backup tool suggestions
I'm looking for an Open Source website backup tool. I'm more interested in Open Source so I can make changes if need be and possibly contribute to the software. Automatic scheduled FTP backups from mutiple web servers.MySQL backups from databases (only partially importan...

Single V/s Multiple Databases
I've built this web app (php & mysql) which stores information for various organisations (about 20 clients currently).The current scenario stores client-related information in individual databases, so there's 20 client databases and 1 master database.One of the main advantag...

Dead-simple PHP/MySQL blogging tool?
HelloI need a really simple solution to build a one-person blog on a shared host: When the user wants to create/edit a blog entry, he calls a PHP script on the server which will...1. save the raw article into MySQL2. combine the article with a template to turn it onto a complete HTML p...

Multi site wordpress setup
Currently my company has 3 blogs and what I did was to install three instances of wordpress over Apache/MySQL, in different directories. The problem is that I have a Slicehost VPS with 256Mb RAM with Ubuntu8.04 and MySQL is crashing Linux or making it very slow and unresponsive. Is there some kin...

My shared-host tells me that they're throttling my website because of MySQL, what can I do?
My shared-host tells me that they're throttling my website because of MySQL, what can I do?I'm not familiar enough with performance tuning of MySQL, generally MySQL just works for me. What questions do I need to ask to figure out how to fix this? Is this memory? Is this processor? Is thi...

Should I use mysqldump or mysqlhotcopy for MySQL database backups?
I have a WordPress blog running on a MySQL database that I want to back up regularly. Would it be better to use the mysqldump program or the mysqlhotcopy script to make backups? What are the pros and cons of each? Are there any other options I should consider?...