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

learn more… | top users | synonyms

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 ...
1
vote
5answers
565 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
152 views
1
vote
2answers
477 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
24 views

homepage keeps on redirecting to install.php

I don't really have any clue what's causing this. It happened 3 times today already. The site that I'm assigned to work on keeps redirecting to http://atenews.ph/wp-admin/install.php and when I tried ...
1
vote
1answer
174 views

MySQL and SQL inserting data into JavaScript variable! [closed]

I have a javascript file that has the variable named locations, with some data in quotes for example, 'name', '123 lane', and etc. I want the variable to get data from a database and not the plain ...
1
vote
1answer
44 views

Character encoding issue in mysql database when working on a MacBook (OSX 10.10)

I'm attempting to get my web development environment running on my MacBook (OSX 10.10 with MAMP), but I'm stuck on an annoying character encoding issue. When originally developing my site in a Windows ...
1
vote
1answer
30 views

Should I use SQL to save time? and How? [closed]

I created some landing page template in which I test various products. currently it is a .php file which I manually change each time, along with 3 other files, plus an image, and then upload all of ...
1
vote
1answer
60 views

How do I recover WordPress page content from MySQL database?

I have a WordPress site and the database has become corrupted (long story), and it's not backed up. My plan is to create a new WordPress site from scratch and copy all the theme files, images, ...
1
vote
1answer
583 views

Zpanel phpmyadmin lost password

I am moving my websites with cPanel management to a new VPS (more cheap and powerful) with zPanel management (the 10.1.1 version, apparently without huge security holes) But unluckily, I lose all ...
1
vote
2answers
160 views

Possible to have an RDS > 3072GB on AWS?

I am a complete newb to AWS. I have a MYSQL database that is about 4TB and growing each day and would like to move it to AWS. According to this link the maximum allocated storage size is 3072 GB. How ...
1
vote
1answer
63 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
3k 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
185 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
222 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
313 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
146 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
261 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
3k 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
1answer
146 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
111 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 ...
1
vote
0answers
28 views

Easy way to SELECT * with ExternalData in Mediawiki?

The ExternalData extension works fine when you I the column names I am looking for, but if I don't know them in advance I look them up from information_schema and then try and fail to hack them into a ...
1
vote
1answer
39 views

In what location does Tiki store articles: in the file system or in the MySQL database?

I have a dump of the directory structure from an old Tiki website from around 2010 that is no longer up. I would like to view the raw text of the articles but am unable to locate any files that ...
1
vote
0answers
39 views

PHP installation missing while opening website [closed]

All was working fine but then suddenly Your PHP installation appears to be missing the MySQL extension which is required by WordPress came when I try to my site. Hosting:Godaddy PHP version:5.4.26 ...
1
vote
0answers
12 views

How do google bots work for sites that are database driven? [duplicate]

I didn't see this question already asked but I also don't know if this may be called something in particular so my apologies. While learning SQL and PHP I was curious to know how do bots search a ...
1
vote
0answers
136 views

How to query MySQL to build Nginx configuration file?

Is it possible to have a MySQL query in my Nginx config? For example: server { listen 80; $domain = [a way to get the current domain]; $server_info = [a way to do the ...
1
vote
0answers
812 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 ...
1
vote
0answers
27 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 ...
1
vote
0answers
74 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
0answers
16 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 ...
1
vote
1answer
333 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 ...
1
vote
1answer
675 views

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

Who database engine is better, in performance and usability?
1
vote
1answer
93 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 ...
1
vote
1answer
201 views

Automate backing up of MySQL DB on Godaddy Windows account

Does anyone know of a good way to set up an automated backup of our MySQL DB on a Godaddy Windows account? Most articles I have found talk about using mysqldump. But I can't figure out how to do ...
0
votes
2answers
822 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 ...
0
votes
1answer
721 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 ...
0
votes
2answers
152 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 ...
0
votes
4answers
788 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 ...
0
votes
1answer
700 views

Ubuntu server MySQL remote access from MySQL Workbench [closed]

I have a newly install Ubuntu installed the MySQL server. After the basic config: I changed the my.cnf file and commented out the bind_address I can start the server and added iptable for 3306. I ...
0
votes
2answers
803 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 ...
0
votes
1answer
458 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 ...
0
votes
1answer
89 views

Can not access phpMyAdmin

I tried to access phpMyAdmin but I get an error. Cannot connect: invalid settings. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the ...
0
votes
1answer
15 views

Does remote mysql work directly to users?

Recently I started moving my MySql to a remote server to offload the load and bandwith. I thought that when a users connect to the site, the MySql data would be transfer directly to the users, but ...
0
votes
1answer
81 views

Error while importing .sql file in phpMyAdmin

Getting error while importing .sql file in phpMyAdmin please help. Error SQL query: CREATE TABLE `sbbleads_admin` ( `sb_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT , `sb_admin_name` VARCHAR( 255 ) ...
0
votes
1answer
85 views

Allow other people to upload to my home web server (inc mysql)

Apologies if this is on the wrong place. I've set up a web server at home, it's basic and is currently running using xampp, I plan on replacing it with an old mac g5 soon and mamp or individual ...
0
votes
1answer
2k views

Warning: mysql_fetch_array() expects parameter 1 to be resource [closed]

I was trying to connect to my database through PHP but I keep getting the error: Warning: mysql_fetch_array() expects parameter 1 to be resource I do not know what the problem is? This is the ...
0
votes
1answer
234 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 ...