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

learn more… | top users | synonyms

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
161 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 ...
5
votes
3answers
408 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
376 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 ...
2
votes
2answers
1k views

Login script with member area/user

Is there a free script which I can use to: Share some PDF with my partners. But i need the user to reach only those PDFs which they have privileges for. So I need: login script with registration (i ...
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 ...
1
vote
1answer
123 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 ...
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 ...
2
votes
2answers
881 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?
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 ...
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 ...
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 ...
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 ...
3
votes
2answers
718 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 ...
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 ...
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 ...
2
votes
1answer
1k 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 ...
1
vote
1answer
192 views

Looking for company job listing script [closed]

Our company wants to have a simple job listing and resume uploading script. We'll only have a few jobs listed at any one time. Also, they are not interested in an "online application" at this time; ...
2
votes
1answer
559 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
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 ...
4
votes
1answer
438 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 ...
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 ...
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 ...
3
votes
3answers
310 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
2k 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
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
772 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
342 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 ...
1
vote
2answers
185 views

Looking for a FormBuilder that gives me all images and sourcecode to my form

Wow, I started my search this morning and didn't think it would be so difficult to find. I'm just tired of spending hours putting together simple html forms in dreamweaver. I'm an enthusiast web ...
0
votes
2answers
614 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 ...
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 ...
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 ...
1
vote
2answers
603 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 ...
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
323 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 ...
5
votes
5answers
981 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
1answer
131 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).
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 ...
3
votes
1answer
423 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 ...
1
vote
3answers
811 views

Symfony project on multiple servers

How can I use Symfony across multiple servers? I have a high-load project and I want to move parts of it(for example: image handlers, video handlers, registration) to other servers.
2
votes
2answers
4k 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 ...
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 ...
2
votes
2answers
764 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.
2
votes
1answer
300 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
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 ...
-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 ...
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
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 ...