Restore Database through phpMyAdmin

abcde · 04-21-2005, 02:16 PM

I dont have SSH access, but my database is kinda large. what should i do?

when i tried to restore via phpmyadmin i always got timeout problems.

luxinterior · 04-21-2005, 02:19 PM

You need to split it up into chunks. It's a bit of a pain but it's the only way to get it in via phpMyAdmin. Can't remember the size of each chunk of the top of my head but I believe it's something like 1mb. Maybe take a look on Goolge or deja.com and see what you can find out.

Good luck

Lux

abcde · 04-22-2005, 12:17 AM

It really suck that i dont have Shell access to my hosting server.

adam_uk · 04-22-2005, 12:36 AM

cant you request it

or even get your host to do it?

Peter · 04-22-2005, 12:56 AM

yes your best bet would be to ask your host. Most hosts should be happy enough to do it.

04-21-2005, 02:16 PM	THREAD STARTER #1 (permalink)
abcde NamePros Regular Join Date: Feb 2005 Posts: 579	Restore Database through phpMyAdmin I dont have SSH access, but my database is kinda large. what should i do? when i tried to restore via phpmyadmin i always got timeout problems. __________________ Freebies and Giveaways - Printable Coupons - Hot Deals - Coupons - Deal of the Day

04-21-2005, 02:19 PM	#2 (permalink)
luxinterior Senior Member Join Date: Jul 2004 Location: Kizmiaz Posts: 1,091	You need to split it up into chunks. It's a bit of a pain but it's the only way to get it in via phpMyAdmin. Can't remember the size of each chunk of the top of my head but I believe it's something like 1mb. Maybe take a look on Goolge or deja.com and see what you can find out. Good luck Lux __________________ 1 Cent Web Hosting @ Online HostGatorVoucher.com Adsense Hack for Vbulletin - Fully 3.6 Compatible ForexArea.com Free E-Course in Programming EA's

04-22-2005, 12:17 AM	THREAD STARTER #3 (permalink)
abcde NamePros Regular Join Date: Feb 2005 Posts: 579	It really suck that i dont have Shell access to my hosting server. __________________ Freebies and Giveaways - Printable Coupons - Hot Deals - Coupons - Deal of the Day

04-22-2005, 12:56 AM	#5 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	yes your best bet would be to ask your host. Most hosts should be happy enough to do it. __________________ Manage your portfolio using my new Domain Portfolio Management script. Securing Your Domain Name From Theft

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restore database by script	abcde	Programming	7	03-11-2005 02:06 PM
Help on: back up and restore database	abcde	Web Hosting Discussion	4	02-23-2005 01:56 AM
HOWTO: Backup and Restore your MySQL databases with phpMyAdmin	deadserious	Webmaster Tutorials	2	04-05-2004 03:15 PM
help, help, help with phpBB installation	seraph	Programming	2	10-05-2003 10:05 PM
php and phpmyadmin and a database full of tables	adam_uk	Programming	4	09-03-2003 03:37 PM

04-22-2005, 12:36 AM	#4 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	cant you request it or even get your host to do it?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)