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

learn more… | top users | synonyms

3
votes
1answer
453 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
6k 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
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
795 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
309 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
662 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 ...
0
votes
1answer
197 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
168 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
318 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
623 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
366 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
4k 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
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 ...
3
votes
3answers
985 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
170 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
326 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
192 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
218 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
4k 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
267 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 ...
3
votes
4answers
5k 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
9answers
1k 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
232 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 ...
0
votes
1answer
150 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
529 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 ...
3
votes
2answers
1k views

MySQL vs. SQL Server GoDaddy, What is the difference between hosted DB and App_Data Db

I'm using GoDdady for site hosting, and I'm currently using MySQL, because there are less limits on size,etc. My question is what is the difference between using a hosted GoDaddy Db such as MySQL vs. ...
1
vote
5answers
527 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 ...
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
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
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 ...
1
vote
1answer
150 views
1
vote
7answers
243 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
1answer
108 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
2answers
451 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 ...
2
votes
3answers
132 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 ...
0
votes
4answers
661 views

Looking for a simple forum script [duplicate]

Possible Duplicate: What Forum Software should I use? I have a working website and I need to integrate a forum into it. The problem is, I need the forum script to use usernames and ...
8
votes
2answers
535 views

Best Free Web Statistics and Analytics Packages For Sites Using PHP & MySQL

I'm looking for a list of the best free web statistics and analytics packages for my site using PHP & MySQL?
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 ...