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

learn more… | top users | synonyms

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
350 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
207 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
772 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
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
961 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
975 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
380 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
6answers
1k 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
142 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
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 ...
3
votes
1answer
479 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
1k 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.
3
votes
4answers
9k 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
151 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
899 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
320 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
774 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 ...
-2
votes
1answer
108 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
215 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
175 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
337 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?
1
vote
1answer
666 views

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

Who database engine is better, in performance and usability?
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
0
votes
1answer
436 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
4answers
5k 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
144 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 ...
3
votes
3answers
1k views

Storing User-uploaded Images

What is the usual practice for handling user uploaded photos and storing them on the database and server? For a user profile image: After receiving the image file from user, rename file to ...
1
vote
1answer
180 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
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 ...
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
2answers
365 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 ...
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 ...
2
votes
2answers
202 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 ...
1
vote
1answer
224 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 ...
5
votes
2answers
5k views

best way to import 500MB csv file into mysql database?

I have a 500MB csv file that needs to be imported into my mysql database. I've made a php file where i can upload the csv file and it analyses the fields n stuff and does the actual importing. but it ...
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 ...
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 ...
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 ...
3
votes
4answers
269 views

WordPress MySQL Performance

I have a website (www.americanbankingnews.com) that gets 40,000-50,000 page views today. It's currently sitting on a dedicated quad-core Xeon server with 8GB of ram. The site is powered by WordPress ...
4
votes
4answers
6k views

What is the best way to exclude bots from view counts?

My website is counting visitor views on certain pages. I noticed that Google and other Bots are "clicking" to my site like crazy and some of the pages get unrealistic view counts (compared to those ...
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
10answers
2k views

How to check if person doesn't have multiple account?

I have two users in my website with the same IP. I asked them or him, idk, why does he have 2 accounts. He said that other account is owned by his roommate. His roommate uses other computer in my ...
3
votes
2answers
248 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
92 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
6k 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 ...
0
votes
1answer
155 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
652 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 ...