hellkvist.org

[sacr0]

Can anyone do a dump of the clean database to a txt file so n00bs like me can install it with phpMyAdmin?

I can get everything else working but installing the 'usersetup.sql' in it's current format is impossible for me.

Any help please


Thanks

[pollo]

You can import the .sql file into phpmyadmin.
That should do the trick!

goodluck.

[sacr0]

Yeh thing is I tried that

insert into db (host,db,user,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,alter_priv)
values ('localhost','peffisaur','peffisaur','y','y','y','y','y','y','y');

# Please change the password below!!!!
insert into user (host,user,password)
values ('localhost','peffisaur',password('hush-hush'));

so I guess these tables have to be created then as they won't import?

[Peffis]

Without ever having used PHPAdmin I think that on hosted sites where you share databases they usually provide another tool to create the actual database and to create users. At least it was like that at my webhost. But it's possible that PHPAdmin has an interface for this as well.

That's because the statements you have there (the insert into db etc) are to be run on the mysql-db where you probably don't have access. The rest of the statements (the create table ones) are to be run on the peffisaur database and should probably work fine to import.

[sacr0]

Ahhhh All becomes very clear. Thanks Peffis. I get it now.


So I guess I'm out of luck when it comes to manageing the users while on a shared server.

okdoki

[Peffis]

The thing is - you probably don't HAVE to manage users. The "create user" statement there is just the user that the software is connecting to the database. It has nothing to do with the users on Peffisaur...if that was what you thought. There is surely a way to create such a user in a shared hosting environment, if one does not already exist for you. Any username will do. You will just have to change the Peffisaur installation to use that user.

And if you have a limitation on number of databases (some shared hosts have) you could always squeeze the Peffisaur tables into some other database that you already have. So then you would not have to do any of the statements below.

But I cannot give you the details on how to do it on your host. Consult your webhost's support how you create databases and database users. They are probably used to that question and probably have it in an FAQ somewhere.