1 Topic by SuperMAG (edited by SuperMAG 2007-04-01 00:58)

  • Registered: 2007-03-25
  • Posts: 960

Topic: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST EVERY THING ,,''

Explanition:

i was about to install a mod and i backup my db in to a File called something.sql

i am hosting at 110mb.com

they have another type of phpmyadmin .. check it out http://www.110mb.com/phpmyadmin/

i first empty the db and when i import the db again this happened.

http://img261.imageshack.us/img261/946/problem1cn6.jpg

there are not last post or info and when i click on a topic this happens:

http://img261.imageshack.us/img261/2616/problem2wb3.jpg

For Clear Pictures:

1- http://img261.imageshack.us/img261/946/problem1cn6.jpg
2- http://img261.imageshack.us/img261/2616/problem2wb3.jpg

i lost every thing ,, what i do .. can some one help please ... my forum is in maintaince mode so can some one help please ....................

MyFootballCafe.com  is Now Online!
  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

could some one help please

MyFootballCafe.com  is Now Online!
  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

could some body help pleaseeeeeeeeeeeeeeeee ... at least i want to save users what i delete in database to save users and delete posts and threads .................... HELPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP

MyFootballCafe.com  is Now Online!
  • Jansson
  • Former PunBB Developer
  • Offline
  • From: Sweden
  • Registered: 2003-01-06
  • Posts: 856

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

Have you checked is your host make regular backups automatically? Maybe you can try restore one of those?

  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

ok i will ask them but where they save that backups

MyFootballCafe.com  is Now Online!
  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

SuperMAG wrote:

ok i will ask them but where they save that backups

If they have them, then they'll be able to tell you where to get them.

Looking for a certain modification for your forum? Please take a look here before posting.
  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

ok thanks aloooooooooooot but they didnt told me till now  and i dont think they have .. but tell me how do i delete all the posts and threads that are unable to open ... could u please what i do to database to do that ...

MyFootballCafe.com  is Now Online!
  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

if any one can help me ,,, please add me in msn messenger kaka-new@hotmail.co.uk

MyFootballCafe.com  is Now Online!
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

I have a feeling that the exported backup has something wrong with it, but you would need to paste some of it so it can be evaluated

  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

what do u mean smartys .. i didnt understand a word of your last comment

MyFootballCafe.com  is Now Online!
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

There was something wrong with your backup. It's possible that the issue can be corrected, but it's impossible to be sure without seeing the contents of the backup

  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

ok do u need my backup

i can upload it to u if avaliable

MyFootballCafe.com  is Now Online!
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

I can take a look at it

  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

i think it is avaliable

so do u want to see it

MyFootballCafe.com  is Now Online!
  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

ok wait 5 min plz

MyFootballCafe.com  is Now Online!
  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

here is  a link to download : http://live.cricket.world.googlepages.c … _forum.sql

MyFootballCafe.com  is Now Online!
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

Mmm, the backup looks fine at first glance
Could the issue be with the modifications you made to your files?

  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

oh no its not .. nothing changed on its mods .. i always make backups but that was the first time i used backup ... .. hea i noticed that posts and threads are existed in the db but are not visible in the forum ... any way thanks aloooooot for ur help .. if u found any thing could u please post it ... another question .. does db work in ur hosts /// or have same problem like mine ...  u may have noticed i have cleaned the forum ... how can i add only posts and topics to db if restored. ... thanks

MyFootballCafe.com  is Now Online!
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

I don't have a place to check it out right now, but it looks to me like the backup is fine. Did you try with "clean" copies of the files?
And to restore just topics/posts, you would need to edit the file so that the only insert statements are those for the topics/posts tables

  • Registered: 2007-03-25
  • Posts: 960

Re: BIG BIG MYSQL Problem .. i import DB but it didnt Correctly .. I LOST,

ok thanks alooooooooooooooot for your help

MyFootballCafe.com  is Now Online!