Welcome, Guest. Please Login or Register.
November 23, 2017, 07:10:47 PM
Home Help Search Login Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  FAQ  |  Topic: 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 39548 times)
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830



WWW
Re:Whats the best way to back/move up your database?
« Reply #15 on: March 25, 2003, 08:47:14 PM »
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, 04: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, 02: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, 04:21:38 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?
Take a look at this guide.
http://www.penthesilea.ch/yabbutils/save-instr/index-en.php
Logged

Anguz
YaBB God
*****
Posts: 641


llama me?!


WWW
Re:Whats the best way to back/move up your database?
« Reply #19 on: March 26, 2003, 08:01:57 PM »
Reply with quote

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 26, 2003, 08:16:34 PM »
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

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, 02: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, 01: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, 01: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, 02: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, 06: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 03, 2003, 07:15:29 PM »
Reply with quote

You shouldn't need the #!/bin/sh in the cron job.  Maybe try a full path to mysqldump.
Logged

Overlord
Jr. Member
**
Posts: 54


YaBB, I am your llama!


WWW
Re:Faq: HowTo Save/Restore the database data
« Reply #27 on: June 03, 2003, 07:16:56 PM »
Reply with quote

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 03, 2003, 07:18:36 PM »
Reply with quote

Can you run the script fine if you execute it?
Logged

Overlord
Jr. Member
**
Posts: 54


YaBB, I am your llama!


WWW
Re:Faq: HowTo Save/Restore the database data
« Reply #29 on: June 03, 2003, 07:20:21 PM »
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  |  Topic: 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.0.12 | SMF © 2016, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.161 seconds with 19 queries.