Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
15 views

Non-existent tablespace when importing MySQL from phpMyAdmin

I usually export a Drupal database from one instance of phpMyAdmin to another on a different server without any issues but lately I have been getting the error when I import: #3510 - Tablespace ...
17
votes
5answers
27k 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 ...
1
vote
0answers
39 views

mysqli_connect() & GoDaddy (New Versions of PHP) [closed]

I am using GoDaddy to host my website and it says in php that I have a Fatal error: Uncaught Error: Call to undefined function There is a problem when I use "mysqli_connect()" function in ...
1
vote
0answers
26 views

Phpmyadmin - How to let users create and manage their own databases without allowing them to see other databases

In PhpMyAdmin I want to allow certain users the ability to create and manage databases without having to manually give them permission to every database they need. I've noticed when giving a user the ...
0
votes
2answers
1k 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 ...
0
votes
1answer
22 views

Dynamic PHP Pages [closed]

I'm trying to make a database of herbs with their many uses. Instead of making an individual page for every single one of them, I would like to just put the info in MySQL and call it to their ...
3
votes
2answers
669 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 ...
1
vote
0answers
28 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
19 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 ...
2
votes
2answers
475 views

PhpMyAdmin - Changing charset

How may I change the database/Tables/Attributes charset using PhpMyAdmin (No SQL statement, only hand-and-mouse actions) ? I only see the option for the Collation (inter-classement).
0
votes
1answer
55 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 ...
3
votes
6answers
9k 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 ...
1
vote
0answers
16 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
25 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
1answer
4k 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......
2
votes
3answers
10k views

large/huge example databases .sql files to download on the web?

Where can i find really large databases .sql files with 100's MB or a few GB text, 10.000.000 plus rows of text so I can test my sphinx search engine indexing
1
vote
0answers
191 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
0answers
3k views

Can't log in to phpMyAdmin after removing MySQL root password

I get this messege: #1045 - Access denied for user 'root'@'localhost' (using password: YES) I tried changing the password in phpMyAdmin config.inc.php from root to '' but all I got was Cannot connect:...
1
vote
3answers
3k views

Symfony project on multiple servers

How can I use Symfony across multiple servers? I have a high-load project and I want to move parts of it(for example: image handlers, video handlers, registration) to other servers.
4
votes
3answers
5k 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 -...
2
votes
2answers
88 views

mod_rewrite issue, won't work when links contain “-”

I've been looking into mod_rewrite for my simple PHP CMS for a couple of days now and I found a rule that was supposed to work for me: RewriteRule ^(\w+)/?$ view_post.php?url=$1 This is supposed to ...
0
votes
4answers
1k views

Looking for a simple forum script [duplicate]

Possible Duplicate: What Forum Software should I use? I have a working website and I need to integrate a forum into it. The problem is, I need the forum script to use usernames and passwords from ...
3
votes
1answer
62 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 ...
20
votes
4answers
163k 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. ...
4
votes
4answers
23k 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 ...
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 ...
1
vote
0answers
355 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 ...
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 ...
2
votes
2answers
2k views

php+mysql account management software? [duplicate]

I need an account system added to my website as a plugin to all of my HTML pages. The account system plugin needs to,register new users, log in current users, remove users who want to disconnect ...
7
votes
7answers
3k views

Adding a Forum to my site: build one from scratch or use existing open-source platform? [closed]

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
196 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
131 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 ...
4
votes
2answers
13k 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 ...
5
votes
2answers
9k 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 written a PHP script where I can upload the csv file to and it analyses the fields and does the actual importing. but it ...
1
vote
1answer
93 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
736 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
75 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 ...
2
votes
0answers
564 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
100 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 ...
1
vote
0answers
145 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
66 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
1answer
3k views

Managing Xampp on USB for Mac and Windows machines

I am working on some PHP projects (Wordpress mostly) with MySQL databases and primarily use my Windows Desktop to do the work on whilst running Xampp. This all works great until I need to take my ...
2
votes
1answer
516 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
77 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 ...
0
votes
1answer
1k views

SocialEngine installation error 500 (Step 3)

I'm trying to install SocialEngine (clean install, empty database, legal license key) but I ran into this error message 500 at Step 3 of the installation: Step 3: Setting up MySQL Database MySQLi ...
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
174 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 ...
3
votes
6answers
467 views

Joomla couldn't create config files and now PHP files give 500 errors on my hosting

I have been playing with a php CMS site for someone that I am ready to deploy but am running into a couple problems that I assume to be hosting related. I have been developing and playing with it ...

1
2 3 4 5