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

learn more… | top users | synonyms

1
vote
0answers
5 views

Check if record already exists before creating a new record [migrated]

I have the following code which posts from the form to the database by saving what is typed into the form. This works but i would like to know how can i be able to check if the record i am entering ...
1
vote
3answers
28 views

CMS with multiple of single database [closed]

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
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
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
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 ...
1
vote
0answers
26 views

Dedicated Servers: Is one better then two for LAMP pseudo HA setup? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I know there are zillions of commentary about hosting out there, but I haven't read much about this. Our current ...
1
vote
0answers
70 views

Determining VPS requirements for a website [closed]

I am on the lookout for another webhosting provider but I'm unsure what to really look for. My current hosting package is as follows: VMware vCloud Premier VM 10GB storage 3GB vRAM 2 vCPU's ...
1
vote
0answers
13 views

Server move - DNS change time [duplicate]

Possible Duplicate: best practice to migrate server I'm planning on moving a large active forum to a new server soon. However, the main issue I have is the time it will take for the DNS to ...
1
vote
2answers
1k views

Wordpress 3.3.1 mySQL very high CPU usage [closed]

My host has given me this log and tells me its mySQL overloading my server: | 266976 | db_name | localhost | db_name | Query | 30 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS ...
1
vote
1answer
603 views

MySQL, SQLServer, Oracle, Postgree, CouchDB, MongoDB, Cassandra or SQLite? [closed]

Who database engine is better, in performance and usability?
1
vote
1answer
89 views

MySQL server with website hosting with managed hosting [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I work for a small business, and I am the "IT Department". I also happen to be a summer intern, so after I leave the ...
0
votes
2answers
593 views

Monitoring load/resource drain of individual scripts on apache

We have a website and for some reason lately its been grinding our server to a halt. It has had a spike of traffic, but even still that spike is only possibly 1k or 2k. We installed eAccelerator PHP ...
0
votes
1answer
537 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
2answers
147 views

I'm confused about encryption and SSL

while my friends and I planning to run our own website, we're confused about the encryption where hackers can TAPPING or in social engineering it's WIRE TAPPING, but I don't know how do they call it ...
0
votes
4answers
604 views

Looking for a simple forum script [duplicate]

Possible Duplicate: What Forum Software should I use? I have a working website and I need to integrate a forum into it. The problem is, I need the forum script to use usernames and ...
0
votes
2answers
611 views

How can I create a review site which is similar to craigslist?

I want to create a site where you can review different things in the town. Example could be a Restaurant, a park, a doctor, a school. The user creates review and uploads pic if he has. I want to ...
0
votes
1answer
299 views

Is there a high-load chat software / script out there?

We're in development of a website and we're looking into other options than just developing a chat engine ourselves. We've looked at CometChat and ArrowChat. Which look and seem to be great except ...
0
votes
1answer
9 views

Does remote mysql work directly to users?

Recently I started moving my MySql to a remote server to offload the load and bandwith. I thought that when a users connect to the site, the MySql data would be transfer directly to the users, but ...
0
votes
1answer
24 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
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
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 ...
0
votes
1answer
193 views

Is there any free host which supports php and mySQL in utf-8? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? Is there any free host which supports php and mySQL queries in utf-8? I've already tried to use x10hosting and ...
0
votes
2answers
844 views

PHP 5.3.8 does not active mysql extensions

I'm installing Apache, PHP and MySql on Windows 7 (I need to run Apache under current user instead of a service so I can't use wamp or similar). The thing is PHP does not get to load mysql extensions, ...
0
votes
1answer
322 views

Web server specifications for online Text-based web game

I am developing an online text-based game similar to Mafia wars. Of course I won't expect 20 million players on my site, but I want to choose a web server that is suitable for me. I am a complete ...
0
votes
1answer
186 views

Looking for PHP/MySQL-based ad manager

Could you recommend based on your experience a PHP/MySQL-based admin interface for managing your website ads? In order to be really useful, such application should have: -basic CRM functionality to ...
0
votes
2answers
155 views

How can I do large file delivery system (YouSendIt) on my own server?

I'm wondering if there is a way that I can replicate the large file delivery system on my own server like the way YouSendIt works. I upload a file on a page, server recognizes it and sends an email ...
0
votes
1answer
60 views

How to implement a software trial request form?

On my company's website I want to have a form where a visitor can provide an email address and pass an anti-bot challenge. The server would then email a trial key to the visitor. Background: I am ...
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 ...
0
votes
3answers
454 views

Recommend hosting with fast MySQL database please [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I am frustrated to no end with my current hosting provider, mediaTemple. Yes, they are flashy, and have some decent ...
0
votes
1answer
64 views

Phantom activity on MySQL

This is probably just my total lack of MySQL expertise, but is it typical to see lots of phantom activity on a MySQL instance via phpMyAdmin? I have a shared hosting plan through Lithium, and when I ...
0
votes
1answer
434 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 ...
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 ...
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 ...
0
votes
0answers
57 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 ...
0
votes
0answers
431 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 ...
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 ...
0
votes
1answer
273 views

Where to get a shared hosting with MySQL 5.5 or higher? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I need to utilize the features of 5.5 and my current host (liquid web) doesn't provide 5.5 for their shared plans. I ...
0
votes
1answer
190 views

Webiste Testing for SQL and CSS injection [duplicate]

Possible Duplicate: Tools to check for common vulnerabilities? I would like to ask some tools or code for testing my new created website from SQL or CSS injection. The website in created in ...
0
votes
1answer
187 views

Help me finding a hoster that allows MySQL Replication please [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? Now as I found out here that I should use Replication for my project, I need a Hoster that allows me to do so. ...
0
votes
0answers
87 views

Where can i find free webhosting with pdo mysql and curl enabled? [duplicate]

Possible Duplicate: What is the best free hosting provider for my site? I am looking for a free web host for a existing .com domain with pdo mysql and curl enabled
0
votes
1answer
1k views

Best free Vulnerability Scanners that check your websites PHP & MySQL code? [duplicate]

Possible Duplicate: Best free Vulnerability Scanners that check your websites PHP & MySQL code? I'm looking for a free vulnerability scanner to check whether my website has common ...
-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 ...
-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 ...
-1
votes
1answer
99 views

Which Hosting Plan Should I use for this Web Application [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I am developing a Web Application [PHP & MySQL] which is basically a rating website ( a social bookmarking site ...
-1
votes
4answers
152 views

Hosting plans that allow more then 1 GB for mysql and easier mod_rewrites? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I'm using godaddy and am thinking of moving to another hosting company that allows easier mod_rewrites and a bigger ...
-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.