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

learn more… | top users | synonyms

0
votes
0answers
7 views

Schedule MediaWiki database maintenance job?

We run a MediaWiki installation for a single site on a VM. We find that we have to repair the mywiki_revision table weekly. It seems to be related to the Sunday backup that runs. We were OK with a ...
2
votes
3answers
1k views

How to find out what is causing “Entry Process” limit?

We're using an OpenCart 1.5.5.1 custom theme for our site. Well it hasn't been smooth sailing for us and we are facing problem after problem. So far the gist of it is we're currently on a business ...
4
votes
5answers
7k 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 ...
0
votes
2answers
881 views

How can I create a review site which is similar to craigslist? [closed]

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
57 views

How do I replace a MySQL Database?

I created a database on the host server using PHPMyAdmin. I exported the database for local development and have since added data and changed the schema slightly. How can I replace the database on ...
0
votes
1answer
18 views

Possible to make virtual servers on hosted web server? [closed]

I own a debian root web server at an ISP. By own I mean, I rent the server with a package, I do not own the hardware and such. No plesk or anything else. All configuration is done by hand (well, a ...
2
votes
2answers
63 views

How to analyse website performance

I've tried searching a lot and basically here is the problem. I have a website but I'm unable to pin point the reasons of why the performance of the website is so slow. We have shifted to a high end ...
0
votes
2answers
63 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
1answer
86 views

How to secure database access

I am developing a personal web-site with a lot of relatively sensitive (genealogical) information stored in a MySQL database. The site engine is written in PHP. So far (prototype phase) I have only ...
1
vote
4answers
5k 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 ...
3
votes
2answers
171 views

Does Google Show Phpmyadmin URL of site in search result

I've extracted phpmyadmin in public folder, and named it phpmyadmin-012940912830 Now I can access it using, mysiteurl.com/phpmyadmin-012940912830, I don't want anyone to know about this URL but what ...
1
vote
1answer
53 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 ...
0
votes
0answers
84 views

Caching layer with DynamoDB?

I am programming a cloud web hosting website. All pages we host are created with our page creator software and they are only html and JavaScript. I am currently storing web pages in a mysql database ...
1
vote
2answers
176 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
51 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
31 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 ...
0
votes
0answers
45 views

Importing opencart 1.5.4 database into 1.5.4.6 version

Hi when can someone give an idea how recover from an 1064 error when trying to import opencart 1.5.4 database into 1.5.6.4 version? For more info check out the attached image.
1
vote
1answer
311 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
497 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 ...
2
votes
1answer
117 views

Wordpress plugin not working after moving domains - I get this error message

I have moved a wodpress website to a new domain with a new host. The website looks, fine and most of the wp-admin area works just fine too. However, certain pages on the admin area don't display and ...
1
vote
1answer
80 views

Where does TWiki store articles: in the file system or in the MySQL database?

I have a dump of the directory structure from an old TWiki 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 ...
6
votes
2answers
17k views

How to create separate users in phpmyadmin, each one can't see others databases?

I am using phpmyadmin to control mysql on my server, now i want to create some users to access this admin tool, what i want is to make each user can create databases but can't see others databases. ...
1
vote
1answer
52 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 ...
7
votes
2answers
1k views

Make Google index over 90,000 user profiles

I have a large amount of user profiles hosted in this schema https://example.com/stats.php?player=name (It's not the prettiest URL, but .htaccess dramatically slows down my site and I don't understand ...
1
vote
1answer
32 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
100 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, ...
3
votes
1answer
49 views

Magento Backup using mysqldump

I have website using magento installed in ubuntu ec2 server. I would like to do a backup of the whole magento website. I stumbled on an article that tells me to run this command ...
3
votes
2answers
368 views

Sync MySQL databases?

I'm a first-time XAMPP user and was wondering what is the method of making sure my local test MySQL database is synced with the live remote database. Or, how do I 'push' the local database to the live ...
2
votes
2answers
407 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
63 views

Basic looping on PHP for web design [closed]

I am very much a newbie in PHP. Could you tell me about basic looping in PHP if I want create a web design. Also, how do I connect to a MySQL database?
1
vote
2answers
100 views

Should I learn html/css before php even for using database? [closed]

I have seen lots of questions about this topic and all of them were asking whether someone, who wants to use PHP for "building web pages", should learn HTML first, or not? Most of the answers said ...
1
vote
1answer
829 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 ...
2
votes
2answers
251 views

How does mediawiki save the passwords?

I have mediawiki installed in my local machine. I had to use a form outside wiki which asks the user to upload files with the wiki username and password. In order to achieve this I went through the ...
0
votes
0answers
33 views

mysql open file limit issue [closed]

It is a little hard to explain but I have a WordPress site which runs really fast but every so many hours it is causing a large spike in system cpy utilization. User cpu is way down. Centos 6.5 ...
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 ...
-1
votes
2answers
39 views

Switch to Drupal [closed]

Currently I manage a website written entirely in html5, php, javascript and css3 with a mysql database. The site resides on a dedicated server with CentOS and Plesk is used for management. I thought ...
2
votes
4answers
84 views

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases?

In order to connect to a MySQL database, you typically use the following command: mysql -h host_address database_name -u db_user -p where db_user is associated with the database in question. ...
-4
votes
1answer
76 views

How to block all hacking? [closed]

The title explains most of my question. The OS is linux (Lubuntu). The servers are Apache2 (PHP5), MySQL 5.6 and FTP (Samba).
0
votes
1answer
1k 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 ...
1
vote
1answer
385 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 ...
5
votes
6answers
2k 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
802 views

Virtualmin cannot connect to MySQL database

I have a VPS running Webmin/Virtualmin. I host multiple domains, one of which is a Drupal 7 website that uses a MySQL database. Yesterday I went to 'Manage' the database and found that I recieved the ...
1
vote
0answers
44 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 ...
2
votes
0answers
21 views

Really slow wordpress website admin panel with a total query time 1664ms for the home page [duplicate]

I have a problem with my WordPress website being too slow, I installed a debug bar to check queries in the home page, it reports 202 queries, and a total query time equal to 1665ms. The cpu and the ...
5
votes
3answers
2k views

How can I tell how big my Amazon RDS database (MySQL) is?

I have a MySQL database for my website hosted on Amazon AWS using RDS. It has 5GB of storage available to it. How can I tell how big the data in it actually is (and therefore how much of the 5GB ...
2
votes
0answers
32 views

Store a formula in a table and use the formula in a javascript/PHP function [closed]

I have a MySql database where part of it handles instrument's depth of water. Each instrument has its own formula of calculation how depth the water when the operator collect the reading I stored the ...
5
votes
2answers
6k 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 ...
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 ...
3
votes
1answer
55 views

How do I solve this error when importing MySQL databases into phpMyAdmin?

As part of a system rebuild of my local machine, I have exported all of my MySQL databases using the Export tab in phpMyAdmin. The result is one large file containing each database and their ...
4
votes
4answers
13k 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 ...