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

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.

l33tg33k

Dec 29 2004, 10:26 AM

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

l33tg33k

Dec 30 2004, 08:47 AM

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

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

l33tg33k

Dec 30 2004, 02:01 PM

not me
the first poster
portalku

wildteen88

Dec 30 2004, 02:03 PM

I wasn't saying ut to you l33

l33tg33k

Dec 31 2004, 09:01 AM

oh i see...

portalku

Jan 11 2005, 04:08 AM

Sure Mysql available

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".

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.

portalku

Jan 27 2005, 02:56 AM

Thank's For All Of You
Your Code Is Work

Spesial Thanks For CODEFX

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

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.

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.

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE