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

learn more… | top users | synonyms

0
votes
0answers
8 views

As I can make a test basing on HTML5, CSS3, JavaScript and PHP and save the result in a MySql database? [on hold]

i need help with my final project and it: it As I can make a test basing on HTML5, CSS3, JavaScript and PHP and save the result in a MySql database? Thanks in advance.
0
votes
0answers
4 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
18 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
20 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 ...
2
votes
3answers
242 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 ...
1
vote
1answer
34 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
0answers
12 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
45 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
30 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 ...
4
votes
2answers
11k 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
37 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
25 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
27 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
20 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
2answers
71 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
358 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
30 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
66 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
263 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
77 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 ...
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 ...
0
votes
0answers
19 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
32 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
78 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. ...
-5
votes
1answer
70 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
280 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
1answer
54 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
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
130 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
525 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 ...
0
votes
0answers
9 views

Best Free Webhosting with MySQL & outside access? [duplicate]

I am looking for some free webhosting to test some programs on. Need the following: Ability to point my DNS to it PHP & MySQL Allows outside connections (ie: I can access MySQL from my own ...
1
vote
0answers
33 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 ...
4
votes
3answers
485 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
26 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
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 ...
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 ...
2
votes
1answer
45 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 ...
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
1answer
14 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
61 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?
0
votes
1answer
56 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
3answers
68 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
51 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 ...
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 ...
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 ...
2
votes
3answers
5k views

Accessing PHPMyAdmin via URL (without cPanel)

I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root. I cannot seem to be able to make another account for cPanel either, and research indicates this ...
1
vote
3answers
51 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 ...