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

learn more… | top users | synonyms

2
votes
1answer
555 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 ...
2
votes
1answer
299 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 ...
2
votes
2answers
181 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 ...
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
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 ...
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
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 ...
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
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 ...
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 ...
1
vote
3answers
306 views

Multi site wordpress setup

Currently my company has 3 blogs and what I did was to install three instances of wordpress over Apache/MySQL, in different directories. The problem is that I have a Slicehost VPS with 256Mb RAM with ...
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 ...
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 ...
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
7answers
240 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
3answers
3k views

large/huge example databases .sql files to download on the web?

Where can i find really large databases .sql files with 100's MB or a few GB text, 10.000.000 plus rows of text so I can test my sphinx search engine indexing
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 ...
1
vote
3answers
89 views

What is hosting space and why is it increasing every day?

My hosting's disk space is increasing every day and I just wanted to know, why? I don't upload new files, but it still gets increased by every day. Anyone knows? Thank you.
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?
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
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).
1
vote
3answers
802 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.
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 ...
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
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 ...
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 ...
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 = ...
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 ...
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 ...
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 ...
1
vote
1answer
155 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 ...
1
vote
2answers
4k views

Good php+mysql system for managing library of books (book catalogue/database software)

Anyone know a good web based system to manage libraries (of books)? It's like a book catalogue/database software, but with web interface, because I want people to be able do searches / queries in the ...
1
vote
5answers
516 views

Jokes search engine / PHP based search engine on database

I'm looking for a script, functioning like the Google homepage that fetches data from a database rather than the internet. This is not intended to be a search engine, but a repository of jokes that ...
1
vote
1answer
146 views
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 ...
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
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 ...
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 ...
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 ...
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
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 ...
1
vote
1answer
191 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; ...
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
3answers
3k views

Correct DB details produce “Database server was not found” (Prestashop Installation)

At stage 3 of the Prestashop Installation, I enter the DB details which I know to be correct, and I receive the error: Database server was not found. Please verify the login, password, and ...
1
vote
1answer
138 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
107 views

Thoughts on this approach for a news post caching system?

I'm working on a website which uses /news/title-of-news-article--111.html (111 = unique ID of the news article). I was thinking it might be a good idea to have some form of a caching system for the ...
1
vote
1answer
112 views

Any suggestion on MySQL services?

I would like to separate my production server into 2, one for running code, the other one is for DB, which is MySQL. Is there any suggestion if I would like to subscribe a MySQL service? I have few ...