MySQL is an open-source, relational database management system.

learn more… | top users | synonyms

15
votes
6answers
5k views

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 ...
12
votes
7answers
4k views

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 ...
8
votes
6answers
8k views

What is the best way to exclude bots from view counts?

My website is counting visitor views on certain pages. I noticed that Google and other Bots are "clicking" to my site like crazy and some of the pages get unrealistic view counts (compared to those ...
8
votes
2answers
618 views

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 site using PHP & MySQL?
8
votes
3answers
240 views

Is it worth it to change my entire user images file structure to take advantage of simple browser caching?

On one of my mobile sites, I simply store my user's profile images as '1.jpg' in their user folder, and incrementally go from there for any extra pics they upload. This means that whenever they change ...
7
votes
2answers
1k views

Make Google index over 90,000 user profiles

I have a large amount of user profiles hosted in this schema https://example.com/stats.php?player=name (It's not the prettiest URL, but .htaccess dramatically slows down my site and I don't understand ...
7
votes
1answer
162 views

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 ...
7
votes
5answers
2k views

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 ...
7
votes
6answers
1k views

ASP.NET, PHP, SQL Server, MySQL hosting provider for developer? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I am looking to find a web hosting provider that provides ASP.NET and PHP hosting. The purpose is pretty much just a ...
6
votes
2answers
20k views

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. ...
6
votes
3answers
1k views

Printing Single Quotes from Database to Screen

I have the following string as a varchar field in a MySQL Database: I'm When I perform a query to extract the string and then print it to the screen using the PHP print command, I get: I�m ...
6
votes
1answer
978 views

Security: Hide mysql connection details file

Ok, so I know this must be a very basic question, but my problem is the following: I have developed my first PHP mini-app (so I'm fairly new to this) and I am pretty sure that there are two files of ...
5
votes
3answers
3k views

How can I tell how big my Amazon RDS database (MySQL) is?

I have a MySQL database for my website hosted on Amazon AWS using RDS. It has 5GB of storage available to it. How can I tell how big the data in it actually is (and therefore how much of the 5GB ...
5
votes
1answer
2k views

Is sqlite3 faster than MySQL on shared hosting?

Can sqlite3 be faster than MySQL on shared hosting and small to average websites (less than 500 visitors a day). I have an account in a popular shared hosting provider and I've noticed that it has ...
5
votes
6answers
2k views

Adding a Forum to my site: build one from scratch or use existing open-source platform?

Note: I posted this originally to stackoverflow.com, had it closed, and was told to post it on programmers.stackexchange.com. So I posted it on programmers.stackexhange.com, had it cloased, and was ...
5
votes
4answers
366 views

What database use for huge servers?

Suppose I had a HUGE website (which I don't, but let's suppose), the common MySQL on a single server wouldn't work, because the MySQL server wouldn't be able to handle thousands of requests per second ...
5
votes
2answers
7k views

best way to import 500MB csv file into mysql database?

I have a 500MB csv file that needs to be imported into my mysql database. I've made a php file where i can upload the csv file and it analyses the fields n stuff and does the actual importing. but it ...
5
votes
3answers
1k views

phpMyAdmin: Remove Table Drop and Empty Controls

I'm not sure this is the place to post this as there are very few questions tagged phpMyAdmin; I thought of stackoverflow, but it's not really programming. In any case, mods should feel free to move ...
4
votes
3answers
263 views

Do i need to have a separate page for each article on my website?

I am using a database to store data such as articles, titles, meta and so on. Do I need to Have a separate page for each article so that my articles show up in the list when searched on Google? Is is ...
4
votes
1answer
741 views

Performance : Auto Complete Search for a large amount of data?

I have a table(mysql) containing around 20,000 records and I am trying to build a auto complete search box for my website. Someone told me that auto-complete search for such a large number of records ...
4
votes
1answer
1k views

MySQL can only log in as root, even after creating new users with their own database

Problem: I just set up a Debian Wheezy installation for testing, and installed the LAMP packages and PMA. I can log in as root with my pre-defined password, create/edit/delete both databases and ...
4
votes
1answer
1k views

Has anyone used WebFaction hosting for large traffic websites? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I'm a point where I'm needing to move a large traffic website off of MediaTemple Grid Server (it's maxing out the ...
3
votes
4answers
361 views

Why do some hosting companies restrict the allowed characters in DB names?

GoDaddy allows nothing but letters and numbers in database names. Other hosting companies have similar restrictions. Could there be any technical motivation behind this?
3
votes
6answers
1k views

Dead-simple PHP/MySQL blogging tool?

I 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 ...
3
votes
10answers
2k views

How to check if person doesn't have multiple account?

I have two users in my website with the same IP. I asked them or him, idk, why does he have 2 accounts. He said that other account is owned by his roommate. His roommate uses other computer in my ...
3
votes
2answers
275 views

How can I make my web application faster in Australia when it is hosted in USA

I have www.localo.org hosted on a BlueHost server in USA but I am in Australia and it is INCREDIBLY SLOW! I uploaded it to a Crazy Domains server in Australia and it ran flawlessly. I don't want to ...
3
votes
2answers
199 views

Does Google Show Phpmyadmin URL of site in search result

I've extracted phpmyadmin in public folder, and named it phpmyadmin-012940912830 Now I can access it using, mysiteurl.com/phpmyadmin-012940912830, I don't want anyone to know about this URL but what ...
3
votes
4answers
271 views

WordPress MySQL Performance

I have a website (www.americanbankingnews.com) that gets 40,000-50,000 page views today. It's currently sitting on a dedicated quad-core Xeon server with 8GB of ram. The site is powered by WordPress ...
3
votes
1answer
74 views

Google Analytics not same with my database records

I got a website which will track all the post's visitor view and store each of them in a table with IP address, referrer website and user agent. But I found that in one day I got 100+ rows (pageviews) ...
3
votes
1answer
529 views

Import huge SQL file(6GB+) to MySQL on VPS

I'm trying to import a DB from .sql file, but it's impossible, cause like I said is over 6GB with a lot of records in it and I hit the limit of max_allowed_packet. I use my cPanel user to login in ...
3
votes
4answers
14k views

No databases showing in phpMyAdmin

My website is hosted in shared hosting service and is working fine with updated news stored in MySQL database. To manage the database of website, I install phpMyAdmin in a sub-folder with the same ...
3
votes
1answer
95 views

How to secure database access

I am developing a personal web-site with a lot of relatively sensitive (genealogical) information stored in a MySQL database. The site engine is written in PHP. So far (prototype phase) I have only ...
3
votes
1answer
60 views

Magento Backup using mysqldump

I have website using magento installed in ubuntu ec2 server. I would like to do a backup of the whole magento website. I stumbled on an article that tells me to run this command http://www....
3
votes
2answers
836 views

Looking for full web based booking system

I've searched around here but could not find any booking system that would suit my need. I hope maybe you can help me out. I've already seen question #11379. Solutions provided there are not helping ...
3
votes
2answers
816 views

Remote database connections in mysql and php is it possible?

I need to know whether remote database connections are possible in every server? does every host provides the option for remote DB connection? and further this connection will be the second connection ...
3
votes
2answers
2k views

Good Book for Managing a Linux Web Server?

I'm being thrust into the role of managing my own web server. I will have access to some managed support, but I need a comprehensive resource I can turn to that covers: command line basics, apache and ...
3
votes
2answers
2k views

How do I disable username prefixes on mySQL databases?

I know of the potential risks. The only "useful" thing I've been able to find after Google-ing is this, on the cPanel website, which has no context whatsoever. Does anyone know how to do this? My ...
3
votes
2answers
1k views

MySQL vs. SQL Server GoDaddy, What is the difference between hosted DB and App_Data Db

I'm using GoDdady for site hosting, and I'm currently using MySQL, because there are less limits on size,etc. My question is what is the difference between using a hosted GoDaddy Db such as MySQL vs. ...
3
votes
2answers
167 views

Turning off Webalizer and/or AW Stats

On our dedicated server, we have AW Stats and Webalizer both running. I see I can turn them off in WHM. We use Google Analytics, but also AW Stats sometimes. We never use Webzlier. My question is: ...
3
votes
3answers
2k views

Storing User-uploaded Images

What is the usual practice for handling user uploaded photos and storing them on the database and server? For a user profile image: After receiving the image file from user, rename file to <...
3
votes
2answers
3k views

self hosted open source document management apps?

I'm looking an open source self hosted PHP and MySQL document management apps. security: accessing a document by specific users Work flow: by admin approval (may be two admins) document supporting:...
3
votes
3answers
351 views

Need suggestions for automated file and MySQL database backup on shared web host

We have several websites at multiple hosting companies (all shared hosts - some using cPanel, others using Plesk) and we're looking for a way to backup all files and MySQL databases for each site. We'...
2
votes
6answers
386 views

PHP not working with hosting

I have been playing with a php CMS site for someone that I am ready to deploy but am running into a couple problems that I assume to be hosting related. I have been developing and playing with it ...
2
votes
4answers
157 views

Assuming unique user names / logins, do I also need a unique userID number in the DB?

My users will login into a website using a login of their choosing, but which I will check against the DB to ensure unicity. Given this, should I also have a unique userID in the DB? This could be ...
2
votes
3answers
6k views

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
2
votes
4answers
84 views

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases?

In order to connect to a MySQL database, you typically use the following command: mysql -h host_address database_name -u db_user -p where db_user is associated with the database in question. ...
2
votes
2answers
328 views

Two websites at the same host but on different accounts to use the same database

I have 2 websites and would like to use the same database for both sites. The MySQL database contains just a simple guestbook. The websites are one seperate hosting accounts, but with the same host. ...
2
votes
3answers
136 views

Know a good place to purchase seed data of storenames, addresses, and phone numbers?

I just build a new web app, and I am looking for data to seed it with. Anyone know any good seed data retailers? Or am I missing something and there is a way to do this for free. I am entirely open to ...
2
votes
2answers
368 views

How does mediawiki save the passwords?

I have mediawiki installed in my local machine. I had to use a form outside wiki which asks the user to upload files with the wiki username and password. In order to achieve this I went through the ...
2
votes
2answers
2k views

Can you host Magento on Heroku?

I have Magento running on Heroku but the DB is on Dreamhost (because Heroku doesn't host mySQL). I get a Database connection error from Magento whenever I try to connect. Anyone ever done this?