Simpler SQL Db Handling?

[MartynJ]

I would like to see a php script that can import all the settings (or perhaps during install?) that can create a database based on a .sql file? Rather than have to do it manually via telnet, you should be able to (in the CP) just give the url to an sql file and user/pass then let the php do it all for you.

[Wayne Luke]

If you have to restore your database you won't be able to access the Control Panel. This is the main reason why we don't offer this. You can easily do this using any MySQL front-end such as phpMyAdmin.

[CeleronXT]

Not necessarily.... It depends on why you're restoring it.... If it became completely corrupted, deleted, etc. then you're right. But if it's because some admin went psyco or something and deleted all the posts, threads, forums, etc. then you still would... unless the aforementioned admin de-admined you. :)

[MartynJ]

What I was meaning to say was, for example, imagine my hosting company lost all my stuff, but I was savvy enough to keep a *.sql backup elsewhere, then I would like to be able to install vBulletin again at the host, and on some stage of the install process say "Oh by the way, there's a .sql on server X, restore forums from that." So that as well as reinstalling, you go straight back to where you were without need for telnet and typed SQL commands.

[etones]

Hi, techincally possible, however most likely most hosts wont allow you to execute shell commands on there servers.

Secondly, php has a typical 30 second timeout, most larger forums will require more than 30 seconds to import a database, hence useless.

Regards

[Wayne Luke]

Originally posted by etones
Hi, techincally possible, however most likely most hosts wont allow you to execute shell commands on there servers.


All the good ones give access to SSH. I won't sign with a host that doesn't give shell access.

[etones]

Originally posted by wluke


All the good ones give access to SSH. I won't sign with a host that doesn't give shell access.

well thats great for you, but maybe not for all the droves of newbe vB user ;)

Regards

[Scott MacVicar]

shell is always a requirement for most users, it allows to do many things such as download files from one server to another using wget, editing files using vi instead of having to upload edited versions and finally mysql backups with ease.
Most hosts are now only giving SSH1 or SSH2.

**remembers the day when you got telnet access**

[The Prohacker]

Originally posted by wluke


All the good ones give access to SSH. I won't sign with a host that doesn't give shell access.


Many hosts are going to where you have to ask for shell access, and some are going to the extent that you must sign an agreement and provide ID....



We only give shell access by request, it really doesn't stop anyone from executing a command, but it makes it harder to run things like eggdrops, etc, so far with our policy, we haven't found a user running any eggdrops/bnc's/etc.....