Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How can I create the database in MySQL?!


Guest

Recommended Posts

How can I create the database in MySQL?!

 

 

# mysqladmin -u<root> -p<password> create <database_name>

 

<root> = Username

<password>=password

<database_name> = database Name

 

 

I tried. But not sucessful, why?

Link to comment
Share on other sites

When I don't input the password.

It is pass!

 

But It show "SQL file does not exist: /install/tchinese.sql"

 

why?!

 

How can I ?!

Link to comment
Share on other sites

Hi,

 

For this msg to appear:

 

"SQL file does not exist: /install/tchinese.sql"

 

then possibly you are not running the 'install' from the correct path ??

 

In /var/www/html/catalog/install

 

It has the tchinese.sql file.

 

From http://wiki.oscommerce.com/docsInstallNew

 

you would just need to point your web browser to:

 

/var/www/html/catalog/install

 

which no doubr would translate to:

 

http://localhost/catalog/install

 

Peter

Link to comment
Share on other sites

Help~ ???

What is your server you are using, Host server that is. And secondly what version of PHPMyAdmin are you using? Also make sure you have your permissions set correctly on the install/index.php page

Always remember, we need patience, guidance and most of all understanding.

 

My Contributions

Link to comment
Share on other sites

My default web site path is "/var/www/html"

then the install oscommerce path is "/var/www/html/catalog/install"

 

Now it show "the SQL file does not exist: /install/tchinese.sql"

 

 

Then, Which path is correct!?

Link to comment
Share on other sites

Hi,

 

How to point?!

 

Possibly you will get us to answer your questions better if you can please tell us:

 

1. Where you have the catalog installed ?

 

Is it /var/www/html/catalog , or /var/www/html ?

 

2. Where does http://localhost point to ?

 

Is it /var/www/html , or /var/www ?

 

3. Where is the 'install' path located ?

 

Is it /var/www/html/catalog/install or /var/www/html/install ?

 

Peter

Link to comment
Share on other sites

1. Where you have the catalog installed ?

 

Ans: Inside "/var/www/html"

 

2. Where does http://localhost point to ?

 

Ans: /var/www/html

 

 

3. Where is the 'install' path located ?

 

Ans: Inside "/var/www/html/catalog"

Link to comment
Share on other sites

I discover the "tchinese.sql" file is not the root user permission.

 

Is it need to change the owner of this file ?!

 

 

How to change ?!

 

 

Thanks~

Link to comment
Share on other sites

I sucessfully change the file owner:

chown -c :root tchinese.sql

 

But still don't work!

 

It also display this error "SQL file does not exist: /install/tchinese.sql"

 

WHY????

 

:angry:

Link to comment
Share on other sites

Hi Toni,

 

I notice you are 'bumping' this thread up sometimes with 'smilies'; you might want to read the forum rules:

 

http://www.oscommerce.com/forums/index.php?act=boardrules

 

Bumping

 

Bumping postings to the top of the forum channel listing, made to get more attention to the post, will not be tolerated.

 

When no one has replied to a posting you have made, it is recommended to reply in the same thread with more information that may help in resolving the issue.

 

Peter

Link to comment
Share on other sites

Hi Toni,

 

Have you read this - http://wiki.oscommerce.com/docsInstallNew

 

to ensure that all your paths are defined correctly. It simply sounds like a path problem, because you do have the SQL file in the 'install' path, yet the installation must be looking somewhere else, because it gives the error msg.

 

edit: .. especially the 'Step 4' part.

 

Peter

Link to comment
Share on other sites

I copy the "Install" folder to ./

 

It is sucessfully to install.

 

but in next page, it show:

 

Warning: fopen("/var/www/html\includes/configure.php", "w") - 沒有此一檔案或目錄 in /var/www/html/catalog/install/templates/pages/install_7.php on line 209

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 210

 

Warning: fclose(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 211

 

Warning: fopen("/var/www/html\admin/includes/configure.php", "w") - 沒有此一檔案或目錄 in /var/www/html/catalog/install/templates/pages/install_7.php on line 259

 

Warning: fputs(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 260

 

Warning: fclose(): supplied argument is not a valid File-Handle resource in /var/www/html/catalog/install/templates/pages/install_7.php on line 261

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...