VirtualHost SQL files
Posted by: denisinfrabh (---.virtua.com.br)
Date: August 27, 2018 06:40PM

Folks,
Good morning, how are you?
Using WAMP SERVER and configuring virtual hosts normally.

I would like to know if it is necessary to configure MySQL or MariaDB, so that every time you create virtual hosts in the SQL files, they are in the same virtualhost directory.

Options: ReplyQuote
Re: VirtualHost SQL files
Posted by: Otomatic (Moderator)
Date: August 27, 2018 07:42PM

Hi,

I don't understand the question !

What is the relation between SQL and VirtualHost ?

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.37 - PHP 7.2.12/7.1.24/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
Wampserver 3.1.4 64 bit - Apache 2.4.37 - PHP 7.2.12/7.1.24/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: VirtualHost SQL files
Posted by: denisinfrabh (---.virtua.com.br)
Date: August 27, 2018 07:53PM

Hello,
Firstly, I apologize for the English. I'm using google translator.

When I say SQL, I am referring to the two possibility of using either MySQL or MariaDB.

In my Lab, I am using virtualhost, I then configure the files to be in another drive eg d:
With this I can leave the project files out of the c: unit of the operating system.

I would like the database files to be saved in the same virtualhost folder.

The purpose of this is in case of problems I do not run the risk of losing the files and the database.

Thanks for listening

Options: ReplyQuote
Re: VirtualHost SQL files
Posted by: Otomatic (Moderator)
Date: August 27, 2018 08:11PM

Hi,

t is not possible to define where the database corresponding to a VirtualHost is. This is not a limitation of Wampserver, but of MySQL or MariaDB.

There is only one possibility to define where the databases for MySQL or MariaDB are, it is the line :
datadir=
of the my.ini file

But CAUTION, datadir does not only define the location of your database, but also the location of the databases needed to run MySQL, i.e. mysql, performance_schema and sys databases.
This forms an inseparable whole. You cannot separate user databases from those required for MySQL, with 'free' versions of MySQL or MariaDB.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.4 32 bit - Apache 2.4.37 - PHP 7.2.12/7.1.24/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
Wampserver 3.1.4 64 bit - Apache 2.4.37 - PHP 7.2.12/7.1.24/7.0.32/5.6.38 - MySQL 5.7.23 - MariaDB 10.3.10
PhPMyadmin 4.8.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: VirtualHost SQL files
Posted by: denisinfrabh (---.virtua.com.br)
Date: August 27, 2018 09:21PM

Hello,
Got it.
Previously I tested what you said about changing the base folder of MYSQL.

I kept this option to house the files outside of the operating system.

Thanks for listening.

Options: ReplyQuote


Sorry, only registered users may post in this forum.