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

learn more… | top users | synonyms

0
votes
0answers
6 views

During Mysql cluster replication, slave thread is periodically crashing [on hold]

We have a Master Slave MySQL cluster.. Master Mysql cluster has 2 nodes and Slave MySQL Cluster also has 2 servers. We are using Mysql version as 5.6.20 and NDB version is 7.3.6 When the replication ...
0
votes
0answers
14 views

Database status fetch not working well because of setInterval jQuery method [on hold]

I wanted creating a 'Whats on your mind' kind of page. So I made the database and also the page to post but I am using jQuery to post so I want it to be in a way that the page fetching from the ...
0
votes
0answers
3 views

Will/Does MySQL support DATETIMEOFFSET? [migrated]

I'm currently using a shared hosting plan, and I'm not sure which version of MySQL it's using, but it does not seem to support the DATETIMEOFFSET type. Does a version exists of MySQL that supports ...
3
votes
2answers
141 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
21 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
44 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 ...
0
votes
0answers
29 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
164 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
185 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 ...
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 ...
2
votes
1answer
77 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
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
1answer
55 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 ...
1
vote
1answer
43 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
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
58 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
34 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 ...
1
vote
1answer
53 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
198 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 ...
1
vote
1answer
566 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
141 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
27 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 ...
-1
votes
2answers
36 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
81 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
74 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
86 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
682 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
661 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
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 ...
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 ...
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
2answers
86 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 ...
2
votes
0answers
29 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
3answers
1k 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
1answer
51 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 ...
2
votes
3answers
635 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 ...
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 ...
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
3answers
72 views

How to download database of wordpress from another server?

I am writing a script to take backup of WordPress database through another server If I know ftp and wordpress login details, then how can I download wordpress database from another server. This is ...
1
vote
4answers
56 views

Is it possible to represent MySQL database as text files?

I find manually editing MySQL databases tedious. If the whole database was optionally represented as text files (as per Unix "everything is a file") for quick manually edits, searching and replacing ...
0
votes
1answer
80 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 ) ...
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
3answers
53 views

Moving MySQL database to another server

I have a website build using Q2A engine Since I have about 600 active users there, I'm trying to create a copy of it on a second server for test purposes only. I've copied all the files and ...
2
votes
1answer
2k views

Apache VERY high page load time

My Drupal 6 site has been running smoothly for years but recently has experienced intermittent periods of extreme slowness (10-60 sec page loads). Several hours of slowness followed by hours of normal ...
0
votes
1answer
115 views

PHP web app hosting considerations and advice - high traffic expected from day 1 [duplicate]

I'm in the process of researching hosting providers for a high traffic Facebook application. The client has over 300,000 likes so we can expect quite a bit of traffic when posts are made about it and ...
-2
votes
2answers
122 views

How to use Node.Js in place of MySQL [closed]

I want to know if it's possible to use Node.js in place of MySQL.
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 ...
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
0answers
135 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 ...