Database imported with no data

[ShineGirl]

I have found the root of all my problems.

 

It seems that when the database was imported during install, all the tables in the database were created fine, but no data was entered into them.

 

It all started with the good old error:

Fatal error: Failed opening required 'includes/languages/.php' (include_path='.:/usr/share/pear')

 

I've tried a fresh install a few times, but to no avail.

 

I tried entering the three entries in the languages table manually, and then looked at the other tables - eek!

 

How can I import all the data from the sample database? Or do I need to spend a week or two entering it all manually??! :)

 

I am new to SQL, and have been reading through the documentation, but I'm afraid I'm stumped right about here!

[241]

do you have access to phpMyAdmin as this makes the job easy

[ShineGirl]

Afraid not :/

 

GUI isn't installed (FreeBSD), so it's command line only at the moment!

 

Would copying each section from the original oscommerce.sql file in the install directory and then using:

mysql> LOAD DATA LOCAL INFILE 'whatever.txt' INTO TABLE whatevertable;

 

work, or is there a quicker way of making it populate the whole lot at once?

[241]

have you now gotten access to your admin

[ShineGirl]

Yup, sure have, but it comes up with various errors:

Error: There is currently no default currency set. Please set one at: Administration Tool->Localization->Currencies

ERROR_NO_DEFAULT_LANGUAGE_DEFINED

 

I can access most of the stuff in the 'Tools' section, but all the other sections come up with various SQL errors

[Guest]

from the mysql prompt mysql->

 

remember to use the ; at the end of each statement

 

type in the following:

 

use databasename;

source whatever.sql;

[241]

Cool,

Do you have a backups directory in admin if not create one and chmod 777 for all rights to all things, then place a copy of the sql file in the backups directory, then navigate to your admin, Tools, Database backup and do a restore using the sql

[ShineGirl]

That's done the trick!

 

Thankyou so much :)