News: Welcome to the TinyPortal Support site.

Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

December 10, 2019, 03:15:33 PM

Login with username, password and session length

Recent

Members
Stats
  • Total Posts: 189279
  • Total Topics: 20775
  • Online Today: 386
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 0
Guests: 47
Total: 47

Author Topic: 40 MB database upload restore problem  (Read 2049 times)

0 Members and 1 Guest are viewing this topic.

hartiberlin

  • Guest
40 MB database upload restore problem
« on: April 23, 2007, 09:18:22 AM »
Hi All,
my SMF SQL database is about 40 Mbytes big.

Now at my hosting provider the SQL server crashed:
hardware failure...

Now I try to upload my database to another database server
at their location,
but phpmyadmin always cuts off the database file during upload,
so many tables are missing !

Is there any other tool available, so I can import a database from
SMF 1.1.2 / Tinyportal 0.97
into a new database ?

My hoster servage.net also has a different import tool in their
online file manager, but when I try to import it this way, the
database says, it has got no tables...
so it does also not work !

Hmm...
Is there any other method to reinstall a 40 MB SQL file into a new database ?

Many thanks.

Regards, Stefan.

Offline G6Cad

  • Friends
  • *
  • Posts: 12643
    • FamiljeGodis
Re: 40 MB database upload restore problem
« Reply #1 on: April 23, 2007, 10:01:21 AM »
This is something you need to get help with from simplemachines.org
There are many ways to go with this, and you have them all posted there :)

knat

  • Guest
Re: 40 MB database upload restore problem
« Reply #2 on: April 23, 2007, 09:54:56 PM »

Svaha

  • Guest
Re: 40 MB database upload restore problem
« Reply #3 on: April 24, 2007, 03:12:55 AM »
Most hosts have a limit of about 10,000 inserts /hour. If that's the case you have to chop your database into parts of about 2 Mb. (gzipped)
When the above doesn't work out for you, try mysqldumper ( http://www.mysqldumper.de/en/ )
I use it on all my sites.