Welcome, Guest. Please Login or Register.
April 20, 2024, 10:59:34 AM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  English User Help  |  FAQ  |  FAQ: HowTo Save/Restore the database data « previous next »
Pages: 1 [2] 3 Reply Ignore Print
Author Topic: FAQ: HowTo Save/Restore the database data  (Read 132474 times)
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:Whats the best way to back/move up your database?
« Reply #15 on: March 26, 2003, 01:47:14 AM »		 Reply with quote
There indeed should be no space - it uses a more linux like syntax... imho, better convention.

mysqldump --opt -uUSER -pPASSWORD DBNAME > backup.sql

Might be good though....

-[Unknown]
Logged
Overseer
Sr. Member
****
Posts: 455
Re:Whats the best way to back/move up your database?
« Reply #16 on: March 26, 2003, 09:33:42 AM »		 Reply with quote
ahh cool.. thanks for replies.. so I wont actually have to download the database and re-up it again. (altho i probably will just to have a backup)
kinda like FXPing :)
Logged
I learned that from the G's, a G is an Overseer, the Overseer sees.
More than you do 'cause he gets experienced - Snoop on Daz's OG

Supreme exalted, universal leader, Descendent of the kings and queens, the Overseer
The overlord, cream of the crop, creme de la creme - Gang Starr  Royalty
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:Whats the best way to back/move up your database?
« Reply #17 on: March 26, 2003, 07:15:08 PM »		 Reply with quote
I don't have shell access, but I do have PHPMyAdmin and CPanel

how can I do what David explains with those?
Logged
My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!

WWW
Re:Whats the best way to back/move up your database?
« Reply #18 on: March 26, 2003, 09:21:38 PM »		 Reply with quote
Quote from: Anguz on March 26, 2003, 07:15:08 PM
I don't have shell access, but I do have PHPMyAdmin and CPanel

how can I do what David explains with those?
Take a look at this guide.
http://www.penthesilea.ch/yabbutils/save-instr/index-en.php
Logged

Forum-Forum.com, A Forum For Forum Owners and Enthusiasts!
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:Whats the best way to back/move up your database?
« Reply #19 on: March 27, 2003, 01:01:57 AM »		 Reply with quote
Quote from: David on March 26, 2003, 09:21:38 PM
Take a look at this guide.
http://www.penthesilea.ch/yabbutils/save-instr/index-en.php

thx Dave, that's a great tutorial, but after 10 tries, I wasn't able to complete the whole db transfer before it dropped  :(

so I asked my webhost and he said that I could have "shell access", so could you explain to me what "shell access" is and how exactly I should do what you mentioned earlier?

thx for your help, I'm really new to this
Logged
My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!

WWW
Re:Whats the best way to back/move up your database?
« Reply #20 on: March 27, 2003, 01:16:34 AM »		 Reply with quote
Shell access is like Dos.  It is command line.  You need to use a program like Putty, http://www.chiark.greenend.org.uk/~sgtatham/putty/, to access it.  Your host will have all details as to how to connect.
Logged

Forum-Forum.com, A Forum For Forum Owners and Enthusiasts!
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:Whats the best way to back/move up your database?
« Reply #21 on: March 27, 2003, 07:07:44 AM »		 Reply with quote
thank you David for all your help :)
Logged
My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
Gastovski
Jr. Member
**
Posts: 53


Chicken Chow Mein!

WWW
Re:Whats the best way to back/move up your database?
« Reply #22 on: March 27, 2003, 06:35:05 PM »		 Reply with quote
I have backed up and migrated my forum onto the new server without any hiccups, apart from the fact that the topics do not show up. Anyone know why this would be?

In admin panel it shows the messages, but no topics... :-\
Logged

The Navy Diver is not a fighting man. He is a salvage expert. If it's lost underwater, he finds it. If it's sunk, he brings it up. If it's in the way, he moves it. If he's lucky, he dies young two hundred feet beneath the waves. 'Cause that is the closest he will ever get to being a hero.
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:Whats the best way to back/move up your database?
« Reply #23 on: March 27, 2003, 06:42:40 PM »		 Reply with quote
did you make sure the topics table was there when you migrated?
Logged
My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
Gastovski
Jr. Member
**
Posts: 53


Chicken Chow Mein!

WWW
Re:Whats the best way to back/move up your database?
« Reply #24 on: March 27, 2003, 07:51:01 PM »		 Reply with quote
Yup, weird. I messed around with setting up a new forum in a new database, and  then deleted that db, changing yabb to the falklands db, and it's worked. Looks like a case of buggy mySQL/YaBB. Anyway, thanks ;D
Logged

The Navy Diver is not a fighting man. He is a salvage expert. If it's lost underwater, he finds it. If it's sunk, he brings it up. If it's in the way, he moves it. If he's lucky, he dies young two hundred feet beneath the waves. 'Cause that is the closest he will ever get to being a hero.
Overlord
Jr. Member
**
Posts: 54


YaBB, I am your llama!

WWW
Re:Faq: HowTo Save/Restore the database data
« Reply #25 on: June 03, 2003, 11:03:54 PM »		 Reply with quote
err... I get an error with the cron one..
could someone help?

Code Select

#!/bin/sh
mysqldump -uME -pMYPASS dbname > /home/me/dbname.sql


I get an email from cron saying

Quote
/home/me/backup: mysqldump: command not found

but when I run it from the command line, it is ok.
Logged
-=Overlord=-
Only the dead have seen the end of war (C) Plato
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!

WWW
Re:Faq: HowTo Save/Restore the database data
« Reply #26 on: June 04, 2003, 12:15:29 AM »		 Reply with quote
You shouldn't need the #!/bin/sh in the cron job.  Maybe try a full path to mysqldump.
Logged

Forum-Forum.com, A Forum For Forum Owners and Enthusiasts!
Overlord
Jr. Member
**
Posts: 54


YaBB, I am your llama!

WWW
Re:Faq: HowTo Save/Restore the database data
« Reply #27 on: June 04, 2003, 12:16:56 AM »		 Reply with quote
Quote from: David on June 04, 2003, 12:15:29 AM
You shouldn't need the #!/bin/sh in the cron job.  Maybe try a full path to mysqldump.

Would you know what that is?

And the path #!/bin/sh isn't in my crontab file, it is in the backup.sh script I have crond run.
Logged
-=Overlord=-
Only the dead have seen the end of war (C) Plato
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!

WWW
Re:Faq: HowTo Save/Restore the database data
« Reply #28 on: June 04, 2003, 12:18:36 AM »		 Reply with quote
Can you run the script fine if you execute it?
Logged

Forum-Forum.com, A Forum For Forum Owners and Enthusiasts!
Overlord
Jr. Member
**
Posts: 54


YaBB, I am your llama!

WWW
Re:Faq: HowTo Save/Restore the database data
« Reply #29 on: June 04, 2003, 12:20:21 AM »		 Reply with quote
Yes.
Logged
-=Overlord=-
Only the dead have seen the end of war (C) Plato
Pages: 1 [2] 3 Reply Ignore Print 
YaBB SE Community  |  English User Help  |  FAQ  |  FAQ: HowTo Save/Restore the database data « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.050 seconds with 20 queries.