0
votes
0answers
89 views

How to restore mysql databases from file disk

I used to have a few mysql databases on my system, but my operating system crashed and I cannot access the installed mysql service anymore. The only thing that I have is access to the database files ...
0
votes
0answers
28 views

What is “injection rate” with regard to DB software? How do I tell what it is set to?

I'm trying to set up a specific environment and I've come across a term that I'm not quite familiar with, and searching around has not yielded fruitful results. What does injection rate mean? Does ...
0
votes
0answers
53 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...
0
votes
1answer
794 views

Mysql not starting with changed datadir

I was looking for a way to store my mysql databases on a different partition than the default installation. I found this link and followed the steps. However, after having changed the line datadir = ...
2
votes
1answer
2k views

Grant MySQL user ability to create databases, and only allow them to access those databases

Is it possible to grant a MySQL user the privileges to CREATE new databases, such that they have full access to the databases they create (including the ability to DROP those databases). But other ...
1
vote
1answer
401 views

How to migrate a database from MyISAM to InnoDB?

I am migrating a database with MyISAM tables to an InnoDB engine. Some of the tables in MyISAM have full text indexes. If I have to retain the full text indexes in InnoDB engine, what are the things ...
1
vote
1answer
181 views

Change location of storing mysql database

Im running a linux server and I wondering if and how could I change the contents of Mysql server to be saved on an external hardrive instead of the place where it is being stored now.
0
votes
1answer
124 views

Issue changing mysql password on Debian

I installed mysql on my Debian server. I couldn't get into the database because it kept saying I put in the wrong password so I looked on the internet and found that I could log onto mysql using the ...
1
vote
4answers
141 views

Editing an SQL Database

I'm new to php, so I installed xampp for windows. Is there a windows software for easy MySQL administration? (creating/displaying/editing tables + data, creating relations ..) i've managed to open ...