cannot run mysql file for my nuke website

[guide]

i have been trying to upload mysql database file of my nuke website through phpmyadmin but after uploading the file in the database i found the following message

"Your SQL-query has been executed successfully:
The content of your file has been inserted"

however, there are no tables created under the database at all and there seem to be no change happened inspite of the message confairming the successful execution. i found another message suggesting that "No tables found in database" below the above message. i believe the database file of the nuke website fater running it on the database by itself creats tables in that database. is that right? do i have to create table before running the sql query?

i'm not really sure whether that is something to do with the Character set of the file. the Character set of the file was utt8. i also tried to use ascii but did not solve the problem. if someone knows about resolving this issue please put your suggestion.

[jefreier]

You need to make sure that the tables and such have been created and exist before uploading the file. (In the case of phpNuke/PostNuke and otheres this is done during the execution of the install.php file).

[codefreak]

i have been trying to upload mysql database file of my nuke website through phpmyadmin but after uploading the file in the database i found the following message

"Your SQL-query has been executed successfully:
The content of your file has been inserted"

however, there are no tables created under the database at all and there seem to be no change happened inspite of the message confairming the successful execution. i found another message suggesting that "No tables found in database" below the above message. i believe the database file of the nuke website fater running it on the database by itself creats tables in that database. is that right? do i have to create table before running the sql query?

i'm not really sure whether that is something to do with the Character set of the file. the Character set of the file was utt8. i also tried to use ascii but did not solve the problem. if someone knows about resolving this issue please put your suggestion.

If the Nuke SQL file doesn't have the actual table structures and the statements to create them, then it would definitely need the tables. Open the SQL file in a text editor like Notepad and look to see if it has any CREATE TABLE statements. Generally when you do a mySQL backup, you have to tell it to back up the tables if you want them.

[guide]

thanks jefreier :)

the procedures i followed to install my nuke website are first i copied all folders of php and html files of the nuke in the root folder. second i tried to run the sql file on the database which i have failed to do so far. i'm not actually sure whether these procedures involve in any way the execution of the install.php. if there is another step i need to do like the execution of the install.php please tell me how to execute it. my website is already running in other server and now i'm trying to transfere it to the powweb server. in doing so i backup the datatbase and i copied all of its files to install it in the powweb server. so i do not want to lose any of the structures of the database or to miss any files of my website. bearing this in mind how to install the install.php or to create the table required for running the sql file.

thanks codefreak :)

i checked the sql file and i found CREATE TABLE statements in many places in the sql file like
CREATE TABLE nuke_authors.....
CREATE TABLE nuke_autonews....
CREATE TABLE nuke_bbforum_prune ...and so on

So Nuke SQL file seems to have the actual table structures and the statements to create them. if it is possible to guide me to the proper way to create the table if it is needed for the excution of the sql file

[codefreak]

1. Login to your database from the Powweb phpMyAdmin interface.

2. After you've logged in, click on your database name in the left hand column.

3. You will see a list of tables and a row of tabs. Click the tab called SQL.

4. Under the heading "Location of the textfile:" click the Browse button and choose the SQL file for Nuke.

5. Once you've picked the file, click the Go button and you should see the confirmation message from phpMyAdmin.

Since you mentioned you did see that before, you probably did it this way...but, take a look at the actual statements phpMyAdmin ran. Do you see the CREATE TABLE statments in there? If so, you def should see those tables with their contents in the left hand list after a refresh.

Alternatively, if that still doesn't work for whatever reason, you can cut/paste the create table statements out of the SQL file yourself and run them in the other part of the SQL tab where it says "Run SQL statements on database"

Also, looking at your last post, this is all assuming you already have PHPNuke installed and just want to add something you backed up from your old install to the database. In that case, your best bet is to install PHPNuke from scratch on the new server, then take whatever backups you want to transfer, like your users table and then run the SQL file on the PHPNuke tables.

[guide]

hi codefreak

the procedures i went through to run the sql file were exactly how you put them but with no result.
you said "take a look at the actual statements phpMyAdmin ran. Do you see the CREATE TABLE statments in there?" i did not actually understand where could i see this create table statement. so far i do not see this statement on my database.

[codefreak]

When phpMyAdmin says the SQL statements were executed successfully, it will show you the statements it did below that. As it is, if you want to just move things like your users from one install to the other, you need to install PHPNuke first on the new server/host. Then you can take your backups and add them to the new tables by copy/paste.

[guide]

there is no one seems to be aware of how php nuke is actually installed. it is not my first time to set up a php nuke website and in all servers i did installed a php nuke i was not in such a position. some stress i should install php nuke in the new server to transfare things around. exactly this is what i'm doing, installing the php nuke that needs for the completion to execute the sql file in the first hand. please see the links below for the instruction of installin php nuke website

http://help.powweb.com/tutorials/mysql/phpnuke65.php

the problem here is that phpmyadmin is not working properly because after i execute the file no tables is created which is a surprise to me since it should create all tables required for the installation to be completed. an other surprise to me is that the powweb staff seem to be confused on that issue since they do not seem to be able to guide to solve the problem. they said to me upload the sql file through nuke which is to me unclear how that can be done. from my experiance the execution of the sql file can be done through phpmyadmin in the way i did it and which has also been described by the powweb staff themselves in their tutorials see the link above.

i do not seem to be able to continue with the the powweb server since their technical suport is very weak in comparasion with my previous one.

[RTH10260]

Did you also post in the 'Content Management Systems' forum section ?

[codefreak]

Ok...this isn't rocket science.

There are only 4 steps in the PHPnuke Install file that comes with the download. Why you're not using those instructions I don't know.

If you're simply trying to install PHPNuke on your new host, follow the instructions in that file. When you're ready to create the database tables, follow step two in that file:

2) Now fill the databases with the tables in nuke.sql file:

mysql nuke < nuke.sql

I told you that you can just COPY/PASTE the Create Table statements from the SQL file into phpMyAdmin.

Alternatively, if that still doesn't work for whatever reason, you can cut/paste the create table statements out of the SQL file yourself and run them in the other part of the SQL tab where it says "Run SQL statements on database"