Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
1
vote
0answers
37 views

Cheapest way to use a MySql Database on Microsoft Azure

I am currently evaluating features of Microsoft Azure, and want to try their Azure Database for MySQL service in a little test project. I just need a very basic database with minimal performance and ...
2
votes
1answer
67 views

Why can't update.php connect to my database when my site connects to it just fine?

I'm trying to upgrade my MediaWiki installation. My site runs just fine locally at http://localhost:8888/. I can connect to my database using the "Socket" connection on Sequel Pro on port 8888. My ...
3
votes
1answer
54 views

Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))

Hi all I am fairly new to web development, I've made a couple of my own sites over the years with simple html tables and free webhosts. This time, I have decided to try to host my own site using WAMP ...
1
vote
0answers
289 views

XAMPP phpMyAdmin - different users access same MySQL database [closed]

I have created a MySQL database on MyPHPAdmin (XAMPP 3.2). This is for a group project and I need to have different users access the same database. If they have XAMPP installed on their computer, is ...
1
vote
2answers
787 views

Can I use the Laravel Database Framework without using all of Laravel?

I work at a company with a custom PHP framework we have built over the years. For the most our custom framework suits our needs and includes almost everything Laravel offers, however, our database ...
3
votes
2answers
267 views

Is is OK to back up a WordPress installation while it is serving content?

Running a LEMP stack on Ubuntu 16.04. Found plenty of great documentation for backing up WordPress: Export your database: mysqldump --add-drop-table -h mysql_hostserver -u mysql_username -p ...
1
vote
1answer
95 views

Using MediaWiki and external data, how can I show an image in a page, returned as a blob from a database?

I'm creating a wiki (using MediaWiki) which pulls data from a mySQL instance, and uses this alongside a template to generate the page dynamically. My mySQL instance contains images, stored in a field ...
1
vote
1answer
159 views

How to handle 404 errors that look like SQL errors or hacking attempts?

I have an E-commerce site (built on OpenCart 2.0.3.1). I'm using an SEO pack plugin that keeps a list of 404 errors, so we can make redirects. As of a couple of weeks ago, I keep seeing a LOT of 404s ...
1
vote
1answer
74 views

Using BLOB's for Small Magazine - PHP / MySQL

I'm building a small magazine website which I plan on using daily, but I'm wondering if I should store my article images and videos as physical files or as BLOB in my MySQL Table. My primary concern ...
0
votes
1answer
411 views

Can files such as PDF and JPEG be stored in MySQL BLOBs to keep them off the webserver?

Situation: Users upload documents through web form and the documents are stored in MySQL (InnoDB) as MEDIUMBLOB. The rationality of this versus to store the original document on the webserver is the ...
0
votes
1answer
66 views

Cannot connect to Wordpress MySQL on Fedora 25

On Fedora 25, I want to develop a Wordpress website. Here's a summary of what I did, but I still cannot get it to work and enter Wordpress management panel: 1- I started MySQL by running sudo ...
1
vote
0answers
141 views

Create unique IDs between URL with nginx [closed]

I searched and tried nearly two weeks but don't get any useful result, so I'm trying my luck here before I get crazy: Every existing domain should get an unique ID right after the domain. The ID ...
2
votes
0answers
58 views

Cannot work with mysql Ver 11.18 Distrib 3.23.55, for suse-linux

An older TYPO3 (v4.4.15) database appears to corrupt a local sandbox MySQL 5.7 schema. The server hosting the CMS says $ mysql -V mysql Ver 11.18 Distrib 3.23.55, for suse-linux Details: ...
2
votes
0answers
441 views

Android webserver/mysql stops after some hours of activity (generates 503 status)

We have a number of Samsung android devices running Bit Web server or Kick Web server (and previously KSWeb) and have encountered a recent issue with the web server and mysql server processes being ...
1
vote
2answers
95 views

Creating a board with thousands of forums

I would like to create a message board that has separate forums for each movie, each actor, each director, etc. With modern forum software, is having many thousands of forums like this impractical for ...
2
votes
1answer
358 views

Where can I find User/pass for SQL in PrestaShop website filesystem?

I have just inherited a website from a client who has no idea what their usernames and passwords are for anything. I had to fight the hosts to get access to her files but they are being quite unco-...
1
vote
1answer
73 views

Capturing a variable from a clicked link or url using php [closed]

I've build a php page called pageById.php that pulls in and displays data from a MySQL database, but the query is 'static'. $sql = "SELECT * FROM table WHERE id = 879"; I want to change this so it ...
4
votes
1answer
815 views

How to create user in phpmyadmin to connect two servers?

IP my Website: 192.168.19.33 and IP Database server is: 192.168.19.41. How to create user account in phpmyadmin for the connection between the two servers? And how to edit this setting: ...
0
votes
1answer
159 views

Manually insert text into existing MediaWiki table row?

I'm trying to update a page for a MediaWiki database running MW version 1.26.4. The MediaWiki is currenty suffering unexplained Internal Server Errors, so I am trying to perform an end-around by ...
4
votes
3answers
3k views

Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file

We are trying to upgrade our MediaWiki software. According to Manual:Upgrading -> UPGRADE -> Manual:Backing_up_a_wiki, we are supposed to backup the database with: mysqldump -h hostname -u userid -p -...
3
votes
2answers
6k views

How do I access MySQL console on wampserver 3?

How do I access MySQL console on Wampserver 3? With the earlier versions all you had to do was right click on the Wamp server icon and the option to access MySQL console shows up on the side but ...
3
votes
1answer
2k views

Enable remote access to MySQL server (Linux)

How can I enable remote access to my MySQL Debian server?
2
votes
1answer
83 views

Is it unusual for a hosting company to refuse to update php and mysql?

I am helping another developer on a WordPress site that's for a committee. Which means everything must be decided upon by a bunch of people and not, like, 2. The site is using a WP theme purchased ...
0
votes
1answer
609 views

How much diskspace does a database take? [closed]

I'm looking for hosting at the moment for a wiki and wordpress site. Looking around it looks like most hosts offer a number of databases with a max size of 1GB. With this seeming to be the norm, ...
4
votes
1answer
411 views

Google Analytics not same with my database records

I got a website which will track all the post's visitor view and store each of them in a table with IP address, referrer website and user agent. But I found that in one day I got 100+ rows (pageviews) ...
0
votes
1answer
26 views

What are the options to gradually upgrade from shared hosting if the traffic to my site grows? [duplicate]

I have a site with php+mysql on shared hosting and it works well, has good traffic and I want to plan for the future when traffic to my site grows and shared hosting can't handle it. Since the code ...
2
votes
0answers
14 views

I always wonder how this dynamic site content index very fast? [duplicate]

I am new to this field.Actually I am learning PHP/MYSQL.Five min before I asked a question in StackOverflow.And when I googling this suddenly my question appears.How does StackOverflow index very fast ...
1
vote
0answers
219 views

How can I migrate a phpBB3 forum from MySQL to PostgreSQL?

I have a phpBB3 forum running on a server with MySQL 5.5. I want to migrate the data to a PostgreSQL 9.3 database. I've looked at various guides and tools they were either Very old or Not specific ...
2
votes
3answers
1k 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
34 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
100 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 ...
3
votes
1answer
127 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 ...
3
votes
2answers
343 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
277 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
2k 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
1k 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
36 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
724 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
136 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
264 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
331 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
2k 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
38 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
3k 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, etc......
3
votes
1answer
277 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 http://www....
1
vote
1answer
93 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?
2
votes
2answers
2k 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
2k 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
1k 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 ...
-1
votes
2answers
45 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 ...