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

learn more… | top users | synonyms

0
votes
1answer
10 views

CMS with multiple of single database

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
26 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?
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 ) ...
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
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 ...
3
votes
3answers
849 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 ...
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 ...
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
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. ...
3
votes
9answers
1k 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 ...
0
votes
1answer
433 views

How to using ajax for voting script [closed]

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 can't find a good tutorial ...
1
vote
0answers
489 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 ...
3
votes
4answers
4k 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
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 ...
3
votes
2answers
902 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. ...
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 ...
0
votes
1answer
68 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.
1
vote
4answers
489 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
211 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 ...
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 ...
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 ...
1
vote
1answer
775 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
2answers
158 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 ...
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 ...
8
votes
2answers
502 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?
5
votes
5answers
974 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 ...
1
vote
4answers
2k views

MySQL Online Database

Can anyone suggest a good online free MySQL database. I've tried four till now: db4free FreeMySQL onPhP 000webhost Either of them gave me an timeout error on my connect file or actively restricted ...
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: ...
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 ...
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
4answers
264 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 ...
2
votes
6answers
209 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 ...
0
votes
1answer
532 views

SocialEngine Installation Error 500 (Step 3)

I'm trying to install SocialEngine (clean install, empty database, legal license key) but I ran into this error message 500 at Step 3 of the installation: Step 3: Setting up MySQL Database MySQLi ...
0
votes
1answer
147 views

Is there any good hosting for asp.net and MySQL

I have an account with a hosting company and I have made a project in asp.net and I have used MySQL for the database but... the hosting company has not given my account enough privileges to create a ...
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 ...
2
votes
1answer
1k 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 ...
1
vote
2answers
432 views

Why has mysql stopped working on localhost and how do I fix it? [closed]

I asked this at superuser but I'm having no joy there. I was really hoping someone could help because I'm stumped. I use a MacBook Pro running Mac OS X 10.6.4 For a few years I have used MAMP to ...
6
votes
1answer
358 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 ...
1
vote
2answers
595 views

How to run the PHP script at scheduled time

I need a valuable suggestion that I have to run the PHP script at the scheduled time daily to update some fields in database and to send automated email. How I can do this? Is it possible to write ...
1
vote
1answer
212 views

PHP - How to Backup and Move Wordpress Blog Website to different directory on the same host

I setup a blog for development purposes on the *.com/a/ directory and now want to move it to the root directory *.com on the same host. How do I Backup and Move the Wordpress Blog Website to the ...
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 ...