how to create database in same location of code?

Question

This code generate database correctly. This code is in C:\inetpub\wwwroot\mini location but it generates the database in C:\ProgramData\MySQL\MySQL Server 5.6\data

How to create database in same place where the code is??

<?php

$conn=new mysqli("localhost","root","hiitisme");
$dept=$conn->escape_string($_POST['dept']);
$class=$conn->escape_string($_POST['class']);
$create=$conn->escape_string($_POST['new']);

if($create=="create")
{
    $sql="CREATE DATABASE $dept";
    $conn->query($sql);
    $sql="USE $dept";
    $conn->query($sql);
    $sql="CREATE TABLE $class(Rollno integer,name varchar(30),phone integer(10),email    varchar(20))";
    $conn->query($sql);
    echo "database createed suceefully";
}
?>

Even if you could, I would consider it insecure. I think that this is an XY-question. Instead, I suggest that you explain what you are trying to accomplish by doing this. — MasterAM
– MasterAM, Commented Feb 8, 2014 at 15:11
Although you technically can give an alternative storage location of InnoDB tables, or in Unix make it a symlink, I'm quite sure this is NOT what you want from MySQL. Please explain your requirements, and I'm sure we can come up with a more standard & robust solution. — Wrikken
– Wrikken, Commented Feb 8, 2014 at 15:14

Taz · Accepted Answer · 2014-02-08 15:15:15Z

2

As MasterAM say it is insecure, if i know that , i could download your DB and exploit your's later.
If you absolutely want to do that, just change the "datadir" param in my.ini

answered Feb 8, 2014 at 15:15

Taz

786 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-04-13 12:22:39Z

0

You will have to copy your MySQL database after creation. There is no way to relocate it while executing "CREATE DATABASE".

See https://askubuntu.com/questions/14418/different-locations-for-mysql-databases (I know this is for Linux but still same concept).

edited Apr 13, 2017 at 12:22

CommunityBot

11 silver badge

answered Feb 8, 2014 at 15:13

Tony Stark

2,4781 gold badge25 silver badges45 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:30:55Z

0

You specify the location of data directory in the mysql configuration file, my.ini, not in the code.

On windows,

1 - stop your server
2 - copy the data directory to the location of your choice 
3 - update my.ini (change data directory)
4 - restart mysql

Linux guide How to change MySQL data directory?

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Feb 8, 2014 at 15:13

Nihat

3,1053 gold badges20 silver badges29 bronze badges

Collectives™ on Stack Overflow

how to create database in same location of code?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related