Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

SSL Connection from phpmyadmin to mysql server [closed]

I am getting these errors after this config, I can't get phpmyadmin to work with this config, need help. MySQL server is on different machine. Thanks, $cfg['Servers'][$i]['ssl_cert'] = '/etc/mysql/...
1
vote
0answers
23 views

Why does Dreamweaver save the same .php file twice?

I am creating a website on localhost (WAMP) as of now. I have set up the testing server the new php files that I create are saved in a sub-foldor of www folder specific for my website. [ C:\wamp64\...
0
votes
1answer
18 views

Three of my Wordpress sites got hacked, trying to understand how and how to prevent it [closed]

Today I noticed three of my WordPress sites were hacked and were redirecting visitors to other sites. It took me a while to figure out what exactly was changed. Apparently, "siteurl" and &...
0
votes
0answers
7 views

How to implement traffic correlated ad rate algorithm for different sections of a forum

I'm working on a forum with at least 15 sections. I built an Ad management system that allow users to run their own Ad campaigns and place Ads on any of the sections that best suits their target ...
0
votes
1answer
22 views

Unable to export query result from PHPMyAdmin

I want to export query result in to CSV file from PHPMyAdmin How to do that? See the below picture. Normally I can see the option to check all, edit and delete rows. But when I run this query ...
0
votes
1answer
151 views

How to export query result in a csv file from phpmyadmin

I am running a query in PHPMyAdmin. The query is fine. it's showing the correct result. I want to export that result in a CSV file. It's not on the local server. It's on the webserver This is my ...
1
vote
0answers
14 views

Is it possible to create mysql accounts for 'user' and have that account access a different page of the website? [closed]

I'm creating a website where me "as an admin" can create other accounts for "users". When I login as an admin it will be directed to a page like "superuser.php" where I can create an account for "...
0
votes
1answer
22 views

MediaWiki setup is unable to log into root@localhost DB, but I can log into it via SSH

I'm setting up MediaWiki on an Ubuntu 18.04 server. After installing the mediawiki package I went to web installer and got to the "Connect to database" step. I'm using the following settings:...
0
votes
0answers
14 views

Wich external CMS to use inside existing WebApplication? [duplicate]

A quick question on external CMS usage inside existing web applications. I have a bunch of custom made web applications based on LAMP. Some of them have a lot of landingpages and (as of now) the ...
1
vote
0answers
140 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 ...
3
votes
2answers
419 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
59 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
325 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
1k 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
269 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
115 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
185 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
87 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
607 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
72 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
143 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
65 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: Installing ...
2
votes
0answers
529 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
96 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
485 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
75 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
1k 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
167 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
4k 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 -...
4
votes
2answers
10k 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
96 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
684 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
477 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
243 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
2k 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
35 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
101 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
129 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
365 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
285 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
3k 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
39 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
820 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
141 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
279 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
376 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
2 3 4 5