Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
  #31  
Old 06 Oct 2006, 17:46
mojo8850's Avatar
mojo8850 mojo8850 is offline
 
Join Date: Dec 2004
Location: UK, Yorkshire
I am getting an error Access Denied For User ****

Help Me Only Small Database.
Reply With Quote
  #32  
Old 06 Oct 2006, 22:53
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Real name: Josh
Were you trying to restore the database through phpMyAdmin or via SSH?
Reply With Quote
  #33  
Old 09 Nov 2006, 17:59
Aclikyano Aclikyano is offline
 
Join Date: Apr 2006
OK, I have a problem..What if you dont know the exact path of the db.sql file what would be the best way to find this out through ssh
Reply With Quote
  #34  
Old 05 Jan 2007, 00:10
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Real name: Josh
Uhh I'm not really familiar with SSH but why don't you just use phpMyAdmin or the mySQL dumb tool?
Reply With Quote
  #35  
Old 10 Feb 2007, 14:31
taumau taumau is offline
 
Join Date: Aug 2006
Which way is more safe?

Through phpMyAdmin or SSH?

Thank you
Reply With Quote
  #36  
Old 11 Feb 2007, 16:02
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Real name: Josh
To be honest with you, I have to say that SSH is much safer and probably easier to use than phpMyAdmin. You might have access to shell on your server so you might wanna contact your host first and gain more information regarding this.
Reply With Quote
  #37  
Old 15 Feb 2007, 01:15
taumau taumau is offline
 
Join Date: Aug 2006
I followed all the steps and in the end I downloaded a file with 13,5Mb.

But my forum has 5800 topics and more than 150.000 posts.

Can this be right?


PS- I backup through phpMyAdmin. I donīt have SSH access
Reply With Quote
  #38  
Old 16 Feb 2007, 16:42
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Real name: Josh
Well, if you haven't got any major mods and stuff like that installed on your forum then yeah, how it cannot be right?
Reply With Quote
  #39  
Old 27 Feb 2007, 16:16
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Real name: Erik
hi,
I don't get the "hassle" people make about this.Just login to SSH and type

mysqldump --opt -Q -u mysql_username -p mysql_databasename > file.sql
enter password:Mysql_databasepassword
done as easy as that
Reply With Quote
  #40  
Old 27 Feb 2007, 16:23
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
Some hosts/sites don't have access to SSH?
Interesting...

I use SSH, Its very easy,quick and nice
Reply With Quote
  #41  
Old 16 May 2007, 08:51
Coders Shack Coders Shack is offline
 
Join Date: Apr 2007
Real name: Chad Scira
To login and backup a database in one line:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

To restore a database in one line:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #42  
Old 20 Jun 2007, 02:34
rooney72 rooney72 is offline
 
Join Date: May 2007
I followed step by step the tutorial, SOmehow I might be doing something wrong.

When I imported my very small testing database onto a new server it said it succeeded. When I go into the forum page I expect to see the old members and old threads. Right? After all if I want to transfer my forum onto a new server, then what's the scope of backup.

But in my case NOT. I only see the freshly installed vbulletin on my new server but not the treads and users.

What am I doing wrong?

In just a few words: I want to export my data and transfer it on a new database/server so I won't lose anything from my old forum
Reply With Quote
  #43  
Old 22 Jul 2007, 16:27
Mazoo's Avatar
Mazoo Mazoo is offline
 
Join Date: Apr 2005
Real name: Mazen AlDarrab
That's very useful tutorial .. thanks Snake ...

I'm running a big forum ( DB =~ 2 GB )
and for security I need to know the SSH command that enables me to save a redundant copy of the database their ..
could anyone tell us about their experience in that field ?
And if by chance anyone made a SSH or Linux script or maybe Cron that's automate that process , I hope that I know about it ..



Regards ,
Reply With Quote
  #44  
Old 11 Oct 2007, 15:16
Snake's Avatar
Snake Snake is offline
 
Join Date: Mar 2005
Location: Cleveland, OH
Real name: Josh
Originally Posted by rooney72 View Post
I followed step by step the tutorial, SOmehow I might be doing something wrong.

When I imported my very small testing database onto a new server it said it succeeded. When I go into the forum page I expect to see the old members and old threads. Right? After all if I want to transfer my forum onto a new server, then what's the scope of backup.

But in my case NOT. I only see the freshly installed vbulletin on my new server but not the treads and users.

What am I doing wrong?

In just a few words: I want to export my data and transfer it on a new database/server so I won't lose anything from my old forum
Did you try restoring the database via phpMyAdmin or SSH?

Originally Posted by Mazoo View Post
That's very useful tutorial .. thanks Snake ...

I'm running a big forum ( DB =~ 2 GB )
and for security I need to know the SSH command that enables me to save a redundant copy of the database their ..
could anyone tell us about their experience in that field ?
And if by chance anyone made a SSH or Linux script or maybe Cron that's automate that process , I hope that I know about it ..



Regards ,
Uhh I'm not really sure what you're talking about.
Reply With Quote
  #45  
Old 26 Oct 2007, 19:36
Masiello's Avatar
Masiello Masiello is offline
 
Join Date: Jul 2005
Real name: Antonio
Hello, please any other split tool DB a part BigDumb? That I tried some month a go
For some reason it dont works good for me, I need to remove some queries from my DB that block the importing process.
Reply With Quote
Reply



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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 02:25.

Layout Options | Width: Wide Color: