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

learn more… | top users | synonyms

6
votes
3answers
577 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 ...
1
vote
1answer
407 views

What database engine should I use? [closed]

I don't know if this is the right place to ask this question but I want to become a web programmer for my occupation very soon. I actually went to a store known a PC WORLD in the UK where my laptop ...
0
votes
1answer
403 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 ...
1
vote
2answers
2k views

Could Jekyll/Octopress and other static blogging engines be a good option for a heavy online magazine? [closed]

(Disclaimer: I thought this question should be asked on SuperUser, but it seems that was not the right place. Hope this one is more appropiate.) I'm exploring several options for setting up a static ...
0
votes
3answers
592 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 ...
1
vote
1answer
138 views

How to confirm the Mobile Numbers of my users?

How can I confirm the Mobile Numbers of my users in order to reduce the number of scammers claiming to be in the US but who are actually in another country? A free solution would be preferred. I use ...
5
votes
1answer
1k 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 ...
1
vote
7answers
248 views

Things to consider while choosing a web hosting service? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? Also does the country matter?
1
vote
0answers
27 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 ...
0
votes
1answer
216 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 ...
2
votes
1answer
2k 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
659 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 ...
1
vote
0answers
72 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
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 ...
4
votes
1answer
500 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 ...
3
votes
3answers
324 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. ...
1
vote
3answers
3k views

Create a search for my HTML and CSS site that runs without an internet connection or database?

I have a website that I have written out in plain old HTML and CSS, and want to integrate a search function into it. However, the site is meant to be run offline, from host machines in their local web ...
1
vote
0answers
16 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 ...
0
votes
1answer
307 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
191 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 ...
1
vote
4answers
2k views

Best lightweight PHP/MySQL forum with spam-protection [duplicate]

Possible Duplicate: What Forum Software should I use? I have already searched and checked out posts like this and this but it isn't what I'm looking for. I'm looking for a lightweight ...
3
votes
2answers
1k 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 ...
5
votes
4answers
348 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 ...
0
votes
2answers
736 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 ...
2
votes
3answers
1k 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 ...
0
votes
2answers
952 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, ...
7
votes
6answers
1k 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 ...
0
votes
1answer
361 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 ...
1
vote
1answer
139 views

PhpMyAdmin - Changing charset

How may I change the database/Tables/Attributes charset using PhpMyAdmin (No SQL statement, only hand-and-mouse actions) ? I only see the option for the Collation (inter-classement).
2
votes
1answer
312 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 ...
0
votes
1answer
191 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 ...
1
vote
1answer
90 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
150 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 ...
2
votes
2answers
838 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.
0
votes
2answers
714 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 ...
-1
votes
1answer
101 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 ...
3
votes
6answers
872 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 ...
0
votes
1answer
203 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
2answers
171 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 ...
3
votes
4answers
328 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?
2
votes
1answer
2k views

When I am root, “mysql” connects without a password, even though I've set one [closed]

When I am root, "mysql" connects without a password, even though I've set one: # mysqladmin -u root password 'whatever' # mysql -u root -p Enter password: (typing the 'whatever' above) Welcome to the ...
1
vote
1answer
638 views
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 ...
0
votes
0answers
88 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
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 ...
1
vote
1answer
141 views

free Ad serving solution for smaller php websites

I'm looking for a very simple ad serving solution on my website, that can be hosted on my website. I have used openX and found it a bit complex for my needs. basically I need; A way for advertisers ...
1
vote
1answer
39 views

Problem with login [closed]

I recently moved my website from one host to another. I moved all the files and also the database. Now when I try to log in, it just refreshes the page and nothing happens. The data is being read ...
1
vote
1answer
174 views

Recomendation for Webshop with API

I'm searching for a webshop. The problem with my search is, that the webshop-software of my choice needs to have a useabel API or some interface for external applications. E.g. i need to place orders ...
2
votes
2answers
198 views

Photoblogging engine using PHP and MySQL or PostgreSQL

I am looking for nice looking and with good usability photo blogging software to run on my server. So far I have found PixelPost, Cheesecake and EZPX. PixelPost - look quite abandoned project ...
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 ...