How To Execute sql file to create table

portalku

Dec 21 2004, 03:16 AM

Hi..
Please help me :roll:
How to execute sql file ( e.g nuke.sql ) to create table in mysql data base
I don't have cpanel/PHPmyAdmin.

Whats the comand to execute sql file at my server :?:
my server suport mysql database

Thanks

Comment/Reply (w/o sign-up)

scarface3288

Dec 21 2004, 04:50 AM

1. go to cpanel
2. make sure you create a database and remember
a. User name
b. User password
c. Database name you will need these later
**make sure you remeber these because you will need them later**

3. ok , now go to phpadmin and select the database in the blue colomum to the left that you created. select that file .

4. it will bring you to a nav bar that says Structure< SQL< Export< Search <Query

5 click on the SQl tab

now at the bottom of that page you will see asearch bar that says location of text file, l** leave it on auto detect now press browse and then look for the file name nuke.sql in your computer
**You know where that is**
5 then upload and now you have your tables

6. the last step is configuring your php-nuke with your database real easy. go to your directory and look in the php-nuke file config.php and look for this code.
$dbhost='localhost';
$dbuname='database username here';
$dbpass='database password here ';
$dbname='database name';
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";

if you entered all of those correctly, u should be ok and make sure to redirect your you home file to the php-nuke file

if ll else fails use script libary and install php-nuke from there. thats what i did its real easier.

Comment/Reply (w/o sign-up)

l33tg33k

Dec 29 2004, 10:26 AM

but auto installation really screws up yr theme if you decide to change the forums theme.....

Comment/Reply (w/o sign-up)

l33tg33k

Dec 30 2004, 08:47 AM

hello.....he said he didnt have cpanel.....

Comment/Reply (w/o sign-up)

wildteen88

Dec 30 2004, 01:42 PM

What type of Control Panel have you got on your server then? How do you manage your site?

Have you made sure MySQL is available?

Give more details

Comment/Reply (w/o sign-up)

l33tg33k

Dec 30 2004, 02:01 PM

not me
the first poster
portalku

Comment/Reply (w/o sign-up)

wildteen88

Dec 30 2004, 02:03 PM

I wasn't saying ut to you l33

Comment/Reply (w/o sign-up)

l33tg33k

Dec 31 2004, 09:01 AM

oh i see...

Comment/Reply (w/o sign-up)

portalku

Jan 11 2005, 04:08 AM

Sure Mysql available

Comment/Reply (w/o sign-up)

God

Jan 11 2005, 04:19 AM

CODE

<?php

$handle = mysql_connect("host_name", "username", "password");

$db = mysql_select_db("db_name", $handle);

$query = "CREATE TABLE table_name(var1_type var1, var2_type var2, var3_type, var3...)";

$result = mysql_query($query);

?>

That's a simple one. You'll have to modify it.

EDIT: Oh, and that's using PHP. If you don't have PHP, you can use the mysql console, by running "mysql".

Comment/Reply (w/o sign-up)

Latest Entries

God

Jan 27 2005, 03:20 AM

QUOTE

In php/mysql i want to create 10 tables and add data to each one, but the file size is still small enough...

I'm incorporating this into a broswer based upload/backup script without using cpanel.... in php

Can i just put

$query = \"

all of the sql info - for multiple tables and insertion and updation

\";

$result = mysql_query($query);

in one file.

Will $result process all the queries if they are only defined as one big query? - or do i need to set it for each command

Oooo-that's a tough one!

For that, we go to the PHP manual and their wonderful function reference!

It turns out that you cannot execute more than one MySQL query in one mysql_query() function call. However, browsing the notes for the mysql_query function on their website reveals that someone made a function for running multiple queries:

CODE

//$q is the query string ($thesql returned string)

//$link is the link to the database connection

//returns true or false depending on whether a single query is executed allows you to check to see if any queries were ran

function multiple_query($q,$link) {

$tok = strtok($q, ";n");

while ($tok) {

$results=mysql_query("$tok",$link);

$tok = strtok(";n");

}

return $results;

}

Okay. I'm going to have to explain a couple of things. First, The variables. As it says in the comments, $q is the query (containing multiple queries) you want to run. $link is the link returned by the mysql_connect function.

You're going to have to change your big query. After each individual query, you need to add a ';'. This is because the function tokenizes (separates) the query using these.

If this doesn't work, or if you have more questions, just post again.

Comment/Reply (w/o sign-up)

portalku

Jan 27 2005, 02:56 AM

Thank's For All Of You
Your Code Is Work

Spesial Thanks For CODEFX

Comment/Reply (w/o sign-up)

welbis

Jan 16 2005, 04:52 PM

In php/mysql i want to create 10 tables and add data to each one, but the file size is still small enough...

I'm incorporating this into a broswer based upload/backup script without using cpanel.... in php

Can i just put

$query = "

all of the sql info - for multiple tables and insertion and updation

";

$result = mysql_query($query);

in one file.

Will $result process all the queries if they are only defined as one big query? - or do i need to set it for each command

Comment/Reply (w/o sign-up)

God

Jan 11 2005, 06:20 PM

QUOTE

I make php file with your code, then I upload it, and I run in my browser... Is it correct?

Well, you'll have to put all the statements in your SQL file into the query, but yeah, that's right.

Comment/Reply (w/o sign-up)

hpforums

Jan 11 2005, 05:04 AM

Tell you one thing? Why are you hosting your site where you do not have CPanel or PHPMyAdmin? Better host it with some host that offers CPanel. For e.g. - FNH.

Comment/Reply (w/o sign-up)