[How To] Automatically create MySQL database

[Dennis]

EDIT: We've worked for hours on this script, and it's no longer just one script. The user can now create, delete or reinstall the database with a couple of clicks.

See this thread for more info.

Edited September 27, 2014 by DennisMidjord

[nmo0ory]

Thank You for it

i try it but its don't work

can you tell me how its work ?

dose i need to install something in the server so its run ?

 

sorry for my bad English

[Raizio]

You definitely need to have MySQL installed.

[Dennis]

Yes, you will need to have installed MySQL, and possibly PhpMyAdmin if you want for your clients to be able to import/export databases and such.

[nmo0ory]

i install xampp

so that have phpmyadmin

 

and when i try its come like this

/home/tcadmin/Temp/d0383924-f027-4cd9-af79-7b6c4377f7c9.sh: line 5: mysql: command not found

/home/tcadmin/Temp/d0383924-f027-4cd9-af79-7b6c4377f7c9.sh: line 6: mysql: command not found

/home/tcadmin/Temp/d0383924-f027-4cd9-af79-7b6c4377f7c9.sh: line 7: mysql: command not found

/home/tcadmin/Temp/d0383924-f027-4cd9-af79-7b6c4377f7c9.sh: line 8: mysql: command not found

/home/tcadmin/Temp/d0383924-f027-4cd9-af79-7b6c4377f7c9.sh: line 9: mysql: command not found

Process exited with code 127

[Dennis]

If you've installed xampp, you can't just use the command 'mysql'. You have to point to the place where MySQL is installed in xampp. If I remember correctly, the full path is /opt/lampp/bin/mysql

[nmo0ory]

yah now its work

but after i have other problem

ERROR 1102 (42000): Incorrect database name '/home/tcagame/_Launcher/Temp/04ca9abe-9e02-4d28-ba44-8fd225e6d371.sh'

 

The script has executed successfully. You may close this window.

[Dennis]

Where do you see that? In the console or in the browser?

[nmo0ory]

in the console

in the Actions

[BlackBloods]

Problem Solved

Edited July 17, 2014 by BlackBloods

[BlackBloods]

This is the script for creating database,

 

can i get the script for deleting database ?

[Dennis]

If you want to delete a database, you just have to use the sql commands for it.

[Dennis]

We're now selling an advance edition of this script.

[loadcore]

For those who do not want to pay, the man took the data here.

http://clientforums.tcadmin.com/showthread.php?t=11414

[Dennis]

For those who do not want to pay, the man took the data here.

http://clientforums.tcadmin.com/showthread.php?t=11414

The first script was taken from there, yes. But I'm sure that many of the ones who have already bought the script can ensure you that the script I'm selling doesn't look anything like the one in that thread. As I've already stated, this script prints out all info that is needed

[loadcore]

The first script was taken from there, yes. But I'm sure that many of the ones who have already bought the script can ensure you that the script I'm selling doesn't look anything like the one in that thread. As I've already stated, this script prints out all info that is needed

 

Okay, I'll check it true)

I already paid for and waiting on the mail.

Edited November 13, 2014 by loadcore

[loadcore]

Yesterday I paid the money, the script still does not.

How so?

[Dennis]

The script does not what? If you're Kyvirock, I've already sent you the script. I did that yesterday, and you didn't answer my email :-)

[loadcore]

The script does not what? If you're Kyvirock, I've already sent you the script. I did that yesterday, and you didn't answer my email :-)

I did not come to the script, please send again.

[loadcore]

All come. Let's put. Thank you.

[loadcore]

Do you want to make a video instruction?

Or screenshots?

[loadcore]

I think you sent me a version of Linux only

[Dennis]

I think you sent me a version of Linux only

No. There's both Linux and Windows version in the document.

[loadcore]

No. There's both Linux and Windows version in the document.

I sent you the script back.

There's one version of the same code on Linux

[Dennis]

In the script you send back, this was on the very first line:

 

Right beneath that is the Windows code. If you go to the bottom of the document, the Linux version will be there. I've sold this very same script to a bunch of people, and they've had no problems.