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

learn more… | top users | synonyms

2
votes
1answer
597 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 ...
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
460 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
318 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
0answers
15 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
293 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 ...
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
871 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
345 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
668 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
895 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, ...
6
votes
6answers
947 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
335 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
136 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
305 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
189 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
149 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
780 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
643 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
853 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
196 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
164 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 ...
2
votes
2answers
317 views

how do i choose a web host with support for mysqli extension in php? [duplicate]

Possible Duplicate: How to find web hosting that meets my requirements? I have designed a website running in php and mysql. And I used mysqli extension instead of the normal mysql extension ...
3
votes
4answers
315 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
616 views
4
votes
1answer
936 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
140 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
165 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
190 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 ...
5
votes
3answers
1k views

phpMyAdmin: Remove Table Drop and Empty Controls

I'm not sure this is the place to post this as there are very few questions tagged phpMyAdmin; I thought of stackoverflow, but it's not really programming. In any case, mods should feel free to move ...
2
votes
3answers
131 views

Know a good place to purchase seed data of storenames, addresses, and phone numbers?

I just build a new web app, and I am looking for data to seed it with. Anyone know any good seed data retailers? Or am I missing something and there is a way to do this for free. I am entirely open to ...
2
votes
4answers
156 views

Assuming unique user names / logins, do I also need a unique userID number in the DB?

My users will login into a website using a login of their choosing, but which I will check against the DB to ensure unicity. Given this, should I also have a unique userID in the DB? This could be ...
3
votes
2answers
226 views

How can I make my web application faster in Australia when it is hosted in USA

I have www.localo.org hosted on a BlueHost server in USA but I am in Australia and it is INCREDIBLY SLOW! I uploaded it to a Crazy Domains server in Australia and it ran flawlessly. I don't want to ...
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
5k 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
votes
4answers
154 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 ...
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 ...
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 ...
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 ...