Can I create a db offline & upload it later???

life31 · #1 (**permalink**) 12-15-2007, 05:41 PM

Just wanted to know if i can create a database offline using any programme like MySQL or PHPMyAdmin and then upload the database file to my web server. Does that work?

Where do i upload the database file if it works that way?

Never tried something like this? Did you?

nursehk · #2 (**permalink**) 12-18-2007, 02:46 AM

yes you can create a db offline and its a good idea to make it offline because it would be a great back up no need to worry for the server that you put your DB to go down.

life31 · #3 (**permalink**) 12-18-2007, 06:24 AM

Thanks nursehk! That was indeed helpful.

But one more querry regarding it.
Where do I upload the file on the server? I mean which folder do i upload it to?
Do I need to put it in the same folder wher he site is or is there any specific location for it?

Surreal · #4 (**permalink**) 01-13-2008, 01:20 PM

If your server has PHPMyAdmin, then you can upload it onto there using the "import". You would first need to "export" the database.

It's quite an easy transaction to complete. If your server does not have PHPMyAdmin, nor any other MySQL front end services, then you could use a PHP script to create and upload the database.

life31 · #5 (**permalink**) 01-14-2008, 07:04 AM

Ok you mean that import thing helps to do that. Havent tried till yet but will try cos its lot better doing it ofline and them importing to server from there.

Ya i do have PHPMyAdmin on server as well as system

Surreal · #6 (**permalink**) 01-14-2008, 08:44 AM

Then you should be completely fine when creating a database off line and importing it your your online database.

If you run into any trouble just give me a whirl and I'll see if I can help.

life31 · #7 (**permalink**) 01-14-2008, 01:34 PM

Oh thanks. Ill have to try it out personalyy before asking for some thing else. Will check it out and post here if i face any problems

But if its easy i think i should be able to do that