HELP NEEDED - MySQL DATABASE QUESTION

[sgallasch]

Hello,

I am installing my shop on a new server and have followed the transfer procedure right down to 2nd last task which is, drop the files from the newly created database and upload my current shop database of the same name.

i am using MySQL phpMyAdmin when i go to upload the zipped database i get a exceded upload limit message.

I know this is common and have heard of this before. Can anyone guide me through this?, is it as simple as raising the limit it has stated next to the upload window?

Thanks in advance for any help.

Sean

[Vger]

If you own the server you can control what the phpMyAdmin upload limit is, but you'll also have to allow extra time for the script to run (otherwise it will just time out).

If you are on a shared server, as most people are, then you'll have to do 1 of 2 things:

1. For the totally inexperienced, open the file up and copy and paste the contents in manageable pieces into other files.

2. If you know how to SSH and your host allows it then run the backup into the blank database using SSH.

Vger

[sgallasch]

If you own the server you can control what the phpMyAdmin upload limit is, but you'll also have to allow extra time for the script to run (otherwise it will just time out).

If you are on a shared server, as most people are, then you'll have to do 1 of 2 things:

1. For the totally inexperienced, open the file up and copy and paste the contents in manageable pieces into other files.

2. If you know how to SSH and your host allows it then run the backup into the blank database using SSH.

Vger

Thanks Vger,

I am inexperienced in doing this, so i will do option 1, just so i have understood you correctly, open my database on my PC and cut it up in to smaller zip files which are less in size than the upload limit.

Will it matter about the order i upload the smaller zip files? or this does not matter and the file will build it self back together when it has been uploaded.

Sorry, as this is my first tranfer to a new host. Learning, learning.

[Vger]

I am unsure as to how big your database is, and that decides what your best course of action is.

If it's only 5-10 megabytes unzipped then go down the route of parcelling it up into 1 Mb sized text files (no zipping), but if it's 100 Mbs unzipped then you do need to use SSH.

Vger