MySQL is an open-source, relational database management system.
12
votes
6answers
2k 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 ...
11
votes
7answers
2k 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
3answers
160 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 ...
8
votes
2answers
413 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?
7
votes
1answer
152 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 ...
6
votes
5answers
938 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 ...
6
votes
1answer
155 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 ...
6
votes
6answers
441 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 ...
5
votes
3answers
231 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
...
5
votes
1answer
775 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
5answers
640 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
316 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 ...
4
votes
3answers
141 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
2answers
2k 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 ...
4
votes
1answer
345 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
3answers
711 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
1answer
83 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
510 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
224 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
737 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
2answers
191 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
4answers
251 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
3answers
3k 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.
...
3
votes
1answer
325 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
2answers
326 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
584 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
408 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
9answers
715 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
368 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
46 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
500 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
2k 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 ...
3
votes
3answers
258 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. ...
2
votes
4answers
3k 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 ...
2
votes
6answers
158 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
149 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
2answers
177 views
2 Websites, 1 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
123 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
3answers
761 views
How can I automate retrieval of MySQL databases from shared hosting which disallows remote MySQL connections?
my situation is the following:
I need to do an automated backup of a database
I have only FTP access, PhpMyAdmin, and PHP
So:
No SSH means I can't use mysqldump
No Perl (and no cron) means I ...
2
votes
1answer
85 views
Trouble creating new MySQL user/database with PHPMyAdmin
I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database.
I now want to add a new user and new database. So, I went to the ...
2
votes
2answers
433 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?
2
votes
2answers
2k 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 ...
2
votes
2answers
612 views
phpmyadmin and stored procedures
I'm not able to view subprocedures in Phpmyadmin. I have created a sub procedure via the execute query option. Is there an option to list the subprocedure and edit them.
2
votes
2answers
209 views
how do i choose a web host with support for mysqli extension in php? [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I have designed a website running in php and mysql. And I used mysqli extension instead of the normal mysql extension ...
2
votes
3answers
67 views
Accessing PHPMyAdmin via URL (without cPanel)
I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root.
I cannot seem to be able to make another account for cPanel either, and research indicates this ...
2
votes
2answers
680 views
Login script with member area/user
Is there a free script which I can use to:
Share some PDF with my partners. But i need the user to reach only those PDFs which they have privileges for. So I need:
login script with registration (i ...
2
votes
1answer
668 views
Can't log in to phpMyAdmin after removing MySQL root password
I get this messege:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I tried changing the password in phpMyAdmin config.inc.php
from root to '' but all I got was
Cannot ...
2
votes
1answer
903 views
How to ensure mysql starts automatically if server restarts on Ubuntu Server
Occasionally for various reasons my webhost 'reboots' my VPS after doing some routine maintenance or upgrades. However when they do, or if I reboot the server for any reason myself, mysql doesn't ...
2
votes
1answer
352 views
GoDaddy-Drupal Site down due to mysql password change, how to change it back?
PDOException: SQLSTATE[28000] [1045] Access denied for user 'lev1127301002684'@'188.121.41.131' (using password: YES) in lock_may_be_available() (line 167 of ...
2
votes
1answer
241 views
Could you recommend a good shopping cart script? [duplicate]
Possible Duplicate:
Which Ecommerce Script Should I Use?
I'm looking for a PHP/MySQL script, free or not. Could you please recommend me one that can do the following:
The site I'm trying ...
