Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
20
votes
4answers
163k 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. ...
17
votes
5answers
27k 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 ...
17
votes
6answers
8k 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 ...
15
votes
7answers
5k 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 ...
12
votes
6answers
15k 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 ...
9
votes
2answers
820 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?
9
votes
3answers
313 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
2k 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
7answers
3k views

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

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 ...
7
votes
1answer
191 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
1answer
2k 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 ...
7
votes
5answers
3k 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 from ...
7
votes
6answers
2k 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
3answers
2k 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
3answers
4k 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 <...
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
4answers
393 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
9k 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 written a PHP script where I can upload the csv file to and it analyses the fields and does the actual importing. but it ...
5
votes
3answers
2k 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
320 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
4answers
23k 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 ...
4
votes
2answers
21k views

Add more than one host to user login privileges in phpMyAdmin

As the title reads, I want to add more than one host into the Host field in phpMyAdmin's user privileges, to allow a user to login from a number of different hostnames. How can I accomplish this?
4
votes
2answers
13k views

How do I access MySQL console on wampserver 3?

How do I access MySQL console on Wampserver 3? With the earlier versions all you had to do was right click on the Wamp server icon and the option to access MySQL console shows up on the side but ...
4
votes
2answers
1k 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 ...
4
votes
1answer
488 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) ...
4
votes
2answers
4k 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?
4
votes
1answer
1k 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

How to create user in phpmyadmin to connect two servers?

IP my Website: 192.168.19.33 and IP Database server is: 192.168.19.41. How to create user account in phpmyadmin for the connection between the two servers? And how to edit this setting: ...
4
votes
1answer
3k 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
3answers
5k views

Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file

We are trying to upgrade our MediaWiki software. According to Manual:Upgrading -> UPGRADE -> Manual:Backing_up_a_wiki, we are supposed to backup the database with: mysqldump -h hostname -u userid -p -...
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 resources ...
3
votes
4answers
390 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
467 views

Joomla couldn't create config files and now PHP files give 500 errors on my 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 ...
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
5k 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
309 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
388 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
6answers
9k views

Correct DB details produce “Database server was not found” (Prestashop Installation)

At stage 3 of the Prestashop Installation, I enter the DB details which I know to be correct, and I receive the error: Database server was not found. Please verify the login, password, and ...
3
votes
4answers
281 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
2answers
669 views

Why can't update.php connect to my database when my site connects to it just fine?

I'm trying to upgrade my MediaWiki installation. My site runs just fine locally at http://localhost:8888/. I can connect to my database using the "Socket" connection on Sequel Pro on port 8888. My ...
3
votes
1answer
710 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
1answer
130 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
284 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
1k 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
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
1answer
62 views

Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))

Hi all I am fairly new to web development, I've made a couple of my own sites over the years with simple html tables and free webhosts. This time, I have decided to try to host my own site using WAMP ...
3
votes
2answers
269 views

Is is OK to back up a WordPress installation while it is serving content?

Running a LEMP stack on Ubuntu 16.04. Found plenty of great documentation for backing up WordPress: Export your database: mysqldump --add-drop-table -h mysql_hostserver -u mysql_username -p ...
3
votes
1answer
2k views

Enable remote access to MySQL server (Linux)

How can I enable remote access to my MySQL Debian server?
3
votes
2answers
3k 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
2k 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. ...

1
2 3 4 5