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

learn more… | top users | synonyms

1
vote
3answers
25 views

CMS with multiple of single database [on hold]

I have a couple of questions concerning CMS that I need answered if possible. I need to create a site with a Database. This site will in due time have lots of traffic and many users if things go as ...
1
vote
1answer
28 views

Changing mysql query_cache_limit without having root priviledges

Can query_cache_limit in mysql 5 be set locally for a specific database? I don't have root privileges to change the global variable. Can query_cache_limit be set locally for each database?
1
vote
3answers
43 views

How to download database of wordpress from another server?

I am writing a script to take backup of WordPress database through another server If I know ftp and wordpress login details, then how can I download wordpress database from another server. This is ...
1
vote
4answers
37 views

Is it possible to represent MySQL database as text files?

I find manually editing MySQL databases tedious. If the whole database was optionally represented as text files (as per Unix "everything is a file") for quick manually edits, searching and replacing ...
0
votes
1answer
23 views

Error while importing .sql file in phpMyAdmin

Getting error while importing .sql file in phpMyAdmin please help. Error SQL query: CREATE TABLE `sbbleads_admin` ( `sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT , `sb_admin_name` VARCHAR( 255 ) ...
0
votes
0answers
5 views

Webhosting server Frontcontroller support [duplicate]

I am currently using XAMPP to code my websites, but i want to host it online now. I came across some hosting servers and they had restrictions, one didn't allow the use of a PDO and another didn't ...
0
votes
0answers
10 views

non-invasive database content management? [duplicate]

I work for a group that has an already existing, built-from-scratch LAMP (plus javascript) website. There are currently no content management systems in place, and up to now the method for updating ...
1
vote
0answers
11 views

How do google bots work for sites that are database driven? [duplicate]

I didn't see this question already asked but I also don't know if this may be called something in particular so my apologies. While learning SQL and PHP I was curious to know how do bots search a ...
1
vote
3answers
47 views

Moving MySQL database to another server

I have a website build using Q2A engine Since I have about 600 active users there, I'm trying to create a copy of it on a second server for test purposes only. I've copied all the files and ...
2
votes
1answer
512 views

Apache VERY high page load time

My Drupal 6 site has been running smoothly for years but recently has experienced intermittent periods of extreme slowness (10-60 sec page loads). Several hours of slowness followed by hours of normal ...
0
votes
1answer
69 views

PHP web app hosting considerations and advice - high traffic expected from day 1 [duplicate]

I'm in the process of researching hosting providers for a high traffic Facebook application. The client has over 300,000 likes so we can expect quite a bit of traffic when posts are made about it and ...
0
votes
0answers
14 views

Are there any webhosts that do not require an IP address for direct database access? [duplicate]

I am trying to create a little program with Java/JDBC and MySQL that updates a database on my website periodically. However, this is for work and I am having problems remotely connecting via JDBC to ...
-2
votes
2answers
99 views

How to use Node.Js in place of MySQL [closed]

I want to know if it's possible to use Node.js in place of MySQL.
0
votes
1answer
61 views

Allow other people to upload to my home web server (inc mysql)

Apologies if this is on the wrong place. I've set up a web server at home, it's basic and is currently running using xampp, I plan on replacing it with an old mac g5 soon and mamp or individual ...
1
vote
1answer
787 views

How do I upgrade the PHP MySQL Library?

My PHP MySQL Library version is out of date with my MySQL Vesion. How do I fix this? Server: CentOS 6.3 Steps Taken: FRESH machine originally installed with MySQL 5.1 and PHP 5.3 I uninstalled php ...
0
votes
0answers
56 views

MyBB Maintenance Mode using MySQL

I have small forum using myBB and I need to know how to enable or disable maintenance mode from PHPmyadmin. Please explain How to enable or disable maintenance mode MyBB forum engines using MySQL ...
0
votes
0answers
8 views

OpenSource eCommerce : Catalog Mode [duplicate]

I've been searching for what seems like forever on this one, I require an OpenSource eCommerce solution that has a catalog mode, i.e., a mode that disallows adding items to cart, showing prices etc. I ...
0
votes
0answers
19 views

Free hosting solution for a very low-traffic website [duplicate]

I run a very low-traffic website (about 40 users, basically all of which are daily active on the site). I don't see it changing anytime soon either, as there is no way to sign up on the site right ...
1
vote
0answers
53 views

How to query MySQL to build Nginx configuration file?

Is it possible to have a MySQL query in my Nginx config? For example: server { listen 80; $domain = [a way to get the current domain]; $server_info = [a way to do the ...
1
vote
4answers
490 views

Setting up a LAMP VM server for Development and Testing?

Info: I would like to set up a VM server on my local computer which will serve pages in the exact same way as my current hosting (but only to me on my local computer). I currently pay a big web ...
2
votes
1answer
216 views

Managing Xampp on USB for Mac and Windows machines

I am working on some PHP projects (Wordpress mostly) with MySQL databases and primarily use my Windows Desktop to do the work on whilst running Xampp. This all works great until I need to take my ...
2
votes
0answers
58 views

Good security practice for writing a php/mysql web app [closed]

I'm about to create a web app that is php/mysql based. It should contain multiple users and two levels of admin accounts. It will most likely not be very likely to be attacked in any way. Still I am ...
2
votes
3answers
2k 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 ...
3
votes
2answers
87 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: ...
0
votes
0answers
429 views

PHP not working while selecting multiple columns from a table with MySQL

I am using Apache 2.2. When I am trying to run it my browser is failing to run it, it's showing: This webpage is not available The connection to localhost was interrupted. Error 101 ...
2
votes
1answer
103 views

Unified data source for k2 installed Joomla websites

I am responsible for a few web sites of my organization. I use Joomla! 2.5.9 for those web sites. They all are running at the same server. I use K2 component for content managing. I have a general ...
1
vote
2answers
159 views

Setting up a VM testing server [MySQL, HTML, & PHP webstore] Testing for SQL correctness?

Question: Is there a way to test for correctness once the SQL DB copy has been installed on the local machine so I can confidently move to step number 3? Is there any information on the web that would ...
4
votes
3answers
195 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 ...
6
votes
1answer
363 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 ...
2
votes
0answers
92 views

How many connection can my website have? [closed]

As the traffic increased my website hangs quite regularly. The page visit is now averaging 50k per day. The static page loads fine, but when the page has mysql request it takes too much time to ...
1
vote
1answer
169 views

How many pageviews can my server handle per day?

I'm sharing some space on a dedicated server, but I'm not sure of the exact specifications. It is very fast though, and the person who I'm sharing the server with say they spend about 1400 a month on ...
2
votes
1answer
719 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 ...
1
vote
1answer
125 views

Changing MySQL password in WHM

When resetting an account password in WHM, I get a checkbox with this option: "Sync MySQL password with account password." If an account has multiple MySQL databases, what password is it going to ...
0
votes
2answers
60 views

mod_rewrite issue, won't work when links contain “-”

I've been looking into mod_rewrite for my simple PHP CMS for a couple of days now and I found a rule that was supposed to work for me: RewriteRule ^(\w+)/?$ view_post.php?url=$1 This is supposed to ...
-1
votes
1answer
1k views

How to retrieve an image from MySQL database and display the image as background on body? [closed]

How do I retrieve an image from MySQL database (I know how to display image by retrieving from database but here i want to display differently) i.e. display the image as background on body and image ...
4
votes
1answer
328 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 ...
2
votes
0answers
15 views

Hosting advice for a write-heavy dynamic website [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I have built a website using PHP and MySQL and now I am looking for a hosting service. I am expecting about a 1000 ...
2
votes
1answer
68 views

i got mysql error on this statement i don't know why [closed]

i got mysql error on this statement i don't know why error is: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use ...
3
votes
2answers
489 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 ...
1
vote
1answer
121 views

get mysql_real_escape is giving me errors when I try and add security to my website [closed]

I tried doing this: @ $db = new myConnectDB(); $beerName = mysql_real_escape_string($beerName); $beerID = mysql_real_escape_string($beerID); $brewery = mysql_real_escape_string($brewery); $style = ...
8
votes
3answers
190 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 ...
-1
votes
1answer
84 views

displaying a list of files [closed]

In my web application I have the user sign up for an account, then the account data is saved in a mysql database. The user can then go to "index.php" and log in with their credentials. My application ...
2
votes
2answers
605 views

php+mysql account management software?

I need an account system added to my website as a plugin to all of my HTML pages. The account system plugin needs to,register new users, log in current users, remove users who want to disconnect ...
2
votes
2answers
281 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. ...
0
votes
1answer
1k views

Warning: mysql_fetch_array() expects parameter 1 to be resource [closed]

I was trying to connect to my database through PHP but I keep getting the error: Warning: mysql_fetch_array() expects parameter 1 to be resource I do not know what the problem is? This is the ...
1
vote
2answers
4k 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?
3
votes
2answers
689 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 ...
1
vote
2answers
218 views

Connecting to my new server

I have bought the hosting and now I have successfully created a database and new user and I have enter phpmyadmin from cPanel to create database. Now everything is done. But where can I find ...
1
vote
3answers
160 views

How do I make sure my website is live all the time? [duplicate]

Possible Duplicate: Services to monitor and report if a web site goes down? I've had an interesting day. I've been with a hosting company for 8+ years without a hitch. Today the MySQL on my ...
1
vote
0answers
492 views

Interspire Email Marketer Configuration [closed]

I'm trying to set up Interspire's Email Marketer for a client. I have a working configuration of it on the VPS but this one is having issues! I have transferred it from their old server and setup the ...