Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (vintagerace, capnbob, GregK), 50 Guests and 12 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 88
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 4 1 2 3 4 >
Topic Options
#176880 - 02/02/07 03:06 PM ok Moving day for me...
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
to export my mysql what all options do I need turned on???

also there are the ubbt_ files and w3t files, I think I only need the ubbt_ correct?


Attachments
356-mysql.gif (165 downloads)

Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#176881 - 02/02/07 03:09 PM Re: ok Moving day for me... [Re: Stan]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
You are better doing this from the command line.

MySQL Export: mysqldump -uuser -ppass database_name > dump_name.sql
MySQL Import: mysql -h localhost -uuser -ppass database_name < dump_name.sql
Top
#176883 - 02/02/07 03:11 PM Re: ok Moving day for me... [Re: Ian]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
that is right .... I remember you saying that before..

I use a mac... not sure what to put that command line...
Top
#176884 - 02/02/07 03:15 PM Re: ok Moving day for me... [Re: Stan]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
You need to run something like putty or another ssh terminal software application.

I do not use a mac, so am afraid I cannot comment upon what may work.

You need to ensure though that you have ssh connection to your site.
Top
#176887 - 02/02/07 03:19 PM Re: ok Moving day for me... [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
The w3t_ ones are for the old forum so you won't need those.

As Ian noted, you'll need ssh access to your site to do the command line dump. If you do have ssh access then you can just use the terminal in the mac to ssh to your site.
Top
#176888 - 02/02/07 03:20 PM Re: ok Moving day for me... [Re: Rick]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Thanks Ric - wasn't sure about the Mac.
Top
#176889 - 02/02/07 03:24 PM Re: ok Moving day for me... [Re: Ian]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It's been awhile since I've been on a Mac, but since I spend 90% of my day in some sort of SSH client, when I did have one it was the first thing I looked for ;\)
Top
#176895 - 02/02/07 04:01 PM Re: ok Moving day for me... [Re: Rick]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
ok I downloaded a program called fugu


I then put in this command

MySQL Export: mysqldump -dbo122662337 -XXXXXXXX db122662337 > dump_name.sql

XXXXXXX is my password
I tried it without the "MySQL Export:" and with it... it rejected it...
suspect there is a - missing?

Really appreciate the help from both of you..
Top
#176897 - 02/02/07 04:04 PM Re: ok Moving day for me... [Re: Stan]
jgeoff Offline
Pooh-Bah
Registered: 08/08/06
Posts: 1922
Loc: NJ

You need -uUSERNAME -pPASSWORD (keep the u and p in there)

As for fugu, never used it -- but I like the name \:D
_________________________
GangsterBB.NET (Ver. 7.5.6)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (Win7 and iPhone); No IE, ever!
Top
#176898 - 02/02/07 04:05 PM Re: ok Moving day for me... [Re: Stan]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
You don't need the MySQL Export: portion. You only need:

mysqldump -dbo122662337 -XXXXXXXX db122662337 > dump_name.sql
Top
#176899 - 02/02/07 04:07 PM Re: ok Moving day for me... [Re: Rick]
jgeoff Offline
Pooh-Bah
Registered: 08/08/06
Posts: 1922
Loc: NJ

I didn't even notice that part. But doesn't he also need the -u and -p ? (Just going by another thread's instructions)
_________________________
GangsterBB.NET (Ver. 7.5.6)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (Win7 and iPhone); No IE, ever!
Top
#176904 - 02/02/07 04:16 PM Re: ok Moving day for me... [Re: jgeoff]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
hmmm what does mysqldump: unknown option '-b'
mean?

Am not using putty on a windows machine
Top
#176907 - 02/02/07 04:24 PM Re: ok Moving day for me... [Re: Stan]
jgeoff Offline
Pooh-Bah
Registered: 08/08/06
Posts: 1922
Loc: NJ

I'm guessing that you left out the u and p in username and password?

Try this:

mysqldump -udbo122662337 -pXXXXXXXX db122662337 > dump_name.sql

(you can change dump_name to something memorable)
_________________________
GangsterBB.NET (Ver. 7.5.6)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Chrome, Firefox, & Safari (Win7 and iPhone); No IE, ever!
Top
#176910 - 02/02/07 04:30 PM Re: ok Moving day for me... [Re: jgeoff]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
ok that was quick, but it was only 1.2 megs, does that seem right????
Top
#176914 - 02/02/07 04:32 PM Re: ok Moving day for me... [Re: Stan]
Harold Offline

Registered: 06/04/06
Posts: 775
Loc: Defiance, Ohio
Yes. It's a little over 1,100 files.
Top
#176918 - 02/02/07 04:34 PM Re: ok Moving day for me... [Re: Harold]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
there should be about 100,000 + messages...

That was sooo fast...
Top
#176920 - 02/02/07 04:35 PM Re: ok Moving day for me... [Re: Harold]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
sorry to confuse on the earlier command lines \:\)
Top
#176930 - 02/02/07 04:39 PM Re: ok Moving day for me... [Re: Stan]
Harold Offline

Registered: 06/04/06
Posts: 775
Loc: Defiance, Ohio
 Originally Posted By: Stan
there should be about 100,000 + messages...

That was sooo fast...
No. That shouldn't be right. I thought you meant the Threads download here. Sorry about the confusion.
Top
#176938 - 02/02/07 04:45 PM Re: ok Moving day for me... [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Glad to see my crafted query being used hehe...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#176941 - 02/02/07 04:47 PM Re: ok Moving day for me... [Re: Gizmo]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Also, the query should execute quite fast; and if you where to tar or globalzip the archive it'd compress it down quite a bit as well.

Keep in mind that all data is just text, so it won't be gigantic...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#177039 - 02/02/07 07:02 PM Re: ok Moving day for me... [Re: Rick]
David Dreezer Offline

Pooh-Bah
Registered: 07/21/06
Posts: 2199
If you're on a mac it comes with terminal. works fine. ssh to the server with the database, unless of course you are local to it.

mysqldump --opt -u root -p database > dumpfile.sql

Yes, opt is on by default on newer versions of MySQL but not on older versions. I use it anyway, just in case. Saves a lot of time later.
_________________________
This thread for sale. Click here!
Top
#177052 - 02/02/07 07:49 PM Re: ok Moving day for me... [Re: David Dreezer]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
cli goes so much faster than using scripts ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#177978 - 02/07/07 11:28 PM Re: ok Moving day for me... [Re: Gizmo]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
I so appreciate this community, without it I would be in huge trouble

I was able to dump the mysql, using putty (using a **gasp** windows machine, please do not tell my mac friends /:)

Before I inpmort the file - - Where to a put the file?

WIll be using plesk 8 and the OS is Fedora
Top
#177979 - 02/08/07 12:15 AM Re: ok Moving day for me... [Re: Stan]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
You can place the file on the server anywhere you have access to write to; including your ftp root; simply login to ssh and navigate there and execute the import command.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#178071 - 02/09/07 11:44 AM Re: ok Moving day for me... [Re: Gizmo]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
It looks like I have imported the mysql
But it gives a message about not creating not creating new database, this was not on the old one is this normal?


Attachments
364-Picture1.png (137 downloads)

Top
#178072 - 02/09/07 11:57 AM Re: ok Moving day for me... [Re: Stan]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
I installed a new 7.1 beta on the new server, the same one I am using on the old one...

Did the install as a new install BUT used the existing, recently imported DB

Screen is coming up blank ie
http://clubadventist.org/forum/ubbthreads.php

Feeling like this is coming close to working...

Appreciate this community so much..
Top
#178074 - 02/09/07 12:15 PM Re: ok Moving day for me... [Re: Stan]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
I am using clubadventist.org rather than clubadventist.org on the new server, this will be temp,,,,

HOWever is there something in the imported DB that I need to adjust for this?
Top
#178075 - 02/09/07 12:33 PM Re: ok Moving day for me... [Re: Stan]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
If you have a changed url, then you'll need to edit the config file in the includes directory. You'll see where it has the old URL listed in a couple locations, where you'll need to change it.
Top
#178076 - 02/09/07 12:51 PM Re: ok Moving day for me... [Re: Rick]
Stan Offline

old hand
Registered: 06/05/06
Posts: 708
OK will do that,

(even if i did a clean install?)

Thanks
Top
#178108 - 02/09/07 06:01 PM Re: ok Moving day for me... [Re: Stan]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
BTW, most webhosts will give you a control panel along with phpmyadmin, the control panel is where you'll need to create new databases.

Also, using PHPMyAdmin to import a large backup, you'll likely lag out, you should use command line tools.

As for the blank screen, edit includes/config.inc.php and update all paths and url's.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#178651 - 02/17/07 06:39 PM Re: ok Moving day for me... [Re: David Dreezer]
Conrad Offline
addict
Registered: 08/04/04
Posts: 425
 Originally Posted By: David Dreezer
mysqldump --opt -u root -p database > dumpfile.sql

Yes, opt is on by default on newer versions of MySQL but not on older versions. I use it anyway, just in case. Saves a lot of time later.


I'm really glad I read this as my old server is running a pre-historic version of MySQL that was commonly used around the time when the Egyptians (or was it Marsians?) build the great pyramids.

What does --opt do btw, and how does it save time later?
Top
#178656 - 02/17/07 07:36 PM Re: ok Moving day for me... [Re: Conrad]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
BTW, --opt is enabled by default as of MySQL 4.1 (according to the man page):
 Quote:
As of MySQL 4.1, --opt is enabled by default, but can be disabled with --skip-opt.


As for what it does, quoting the manual again:
 Quote:
· --opt

This option is shorthand; it is the same as specifying
--add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick --set-charset. It should
give you a fast dump operation and produce a dump file that can be
reloaded into a MySQL server quickly. As of MySQL 4.1, --opt is on
by default, but can be disabled with --skip-opt. To disable only
certain of the options enabled by --opt, use their --skip forms; for
example, --skip-add-drop-table or --skip-quick.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#178679 - 02/18/07 05:12 AM Re: ok Moving day for me... [Re: Gizmo]
Conrad Offline
addict
Registered: 08/04/04
Posts: 425
I guess I'm very lucky that Dave mentioned this as my old server is running 4.0.22. All this time I have been making mysql dumps without this, but luckily never had to reimport them back.
Top
Page 1 of 4 1 2 3 4 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image