Register Log In

UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support ok Moving day for me...

Print Thread

Hop To

ok Moving day for me... #176880 02/02/2007 3:06 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	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 http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #176881 02/02/2007 3:09 PM
Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, UK I Ian Carpal Tunnel
Ian Carpal Tunnel I Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, 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

Re: ok Moving day for me... Ian #176883 02/02/2007 3:11 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	that is right .... I remember you saying that before.. I use a mac... not sure what to put that command line... http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #176884 02/02/2007 3:15 PM
Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, UK I Ian Carpal Tunnel
Ian Carpal Tunnel I Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, 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.

Re: ok Moving day for me... Ian #176887 02/02/2007 3:19 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 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.

Re: ok Moving day for me... Rick #176888 02/02/2007 3:20 PM
Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, UK I Ian Carpal Tunnel
Ian Carpal Tunnel I Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, UK	Thanks Ric - wasn't sure about the Mac.

Re: ok Moving day for me... Ian #176889 02/02/2007 3:24 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 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

Re: ok Moving day for me... Rick #176895 02/02/2007 4:01 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	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.. http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #176897 02/02/2007 4:04 PM
Joined: Aug 2006 Posts: 1,649 Likes: 1 NJ jgeoff Pooh-Bah
jgeoff Pooh-Bah Joined: Aug 2006 Posts: 1,649 Likes: 1 NJ	You need -uUSERNAME -pPASSWORD (keep the u and p in there) As for fugu, never used it -- but I like the name GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP

Re: ok Moving day for me... Stan #176898 02/02/2007 4:05 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	You don't need the MySQL Export: portion. You only need: mysqldump -dbo122662337 -XXXXXXXX db122662337 > dump_name.sql

Re: ok Moving day for me... Rick #176899 02/02/2007 4:07 PM
Joined: Aug 2006 Posts: 1,649 Likes: 1 NJ jgeoff Pooh-Bah
jgeoff Pooh-Bah Joined: Aug 2006 Posts: 1,649 Likes: 1 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.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP

Re: ok Moving day for me... jgeoff #176904 02/02/2007 4:16 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	hmmm what does mysqldump: unknown option '-b' mean? Am not using putty on a windows machine http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #176907 02/02/2007 4:24 PM
Joined: Aug 2006 Posts: 1,649 Likes: 1 NJ jgeoff Pooh-Bah
jgeoff Pooh-Bah Joined: Aug 2006 Posts: 1,649 Likes: 1 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.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP

Re: ok Moving day for me... jgeoff #176910 02/02/2007 4:30 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	ok that was quick, but it was only 1.2 megs, does that seem right???? http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #176914 02/02/2007 4:32 PM
Joined: Jun 2006 Posts: 684 Winter Haven, Florida H Harold Addict
Harold Addict H Joined: Jun 2006 Posts: 684 Winter Haven, Florida	Yes. It's a little over 1,100 files.

Re: ok Moving day for me... Harold #176918 02/02/2007 4:34 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	there should be about 100,000 + messages... That was sooo fast... http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Harold #176920 02/02/2007 4:35 PM
Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, UK I Ian Carpal Tunnel
Ian Carpal Tunnel I Joined: Jun 2006 Posts: 3,839 Likes: 1 Somerset, UK	sorry to confuse on the earlier command lines

Re: ok Moving day for me... Stan #176930 02/02/2007 4:39 PM
Joined: Jun 2006 Posts: 684 Winter Haven, Florida H Harold Addict
Harold Addict H Joined: Jun 2006 Posts: 684 Winter Haven, Florida	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.

Re: ok Moving day for me... Rick #176938 02/02/2007 4:45 PM
Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA	Glad to see my crafted query being used hehe... I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum, Scouters World UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: ok Moving day for me... Gizmo #176941 02/02/2007 4:47 PM
Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,367 Likes: 126 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... I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum, Scouters World UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: ok Moving day for me... Rick #177039 02/02/2007 7:02 PM
Joined: Jul 2006 Posts: 2,143 David Dreezer Pooh-Bah
David Dreezer Pooh-Bah Joined: Jul 2006 Posts: 2,143	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!

Re: ok Moving day for me... David Dreezer #177052 02/02/2007 7:49 PM
Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA	cli goes so much faster than using scripts I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum, Scouters World UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: ok Moving day for me... Gizmo #177978 02/07/2007 11:28 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	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 http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #177979 02/08/2007 12:15 AM
Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,367 Likes: 126 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. I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum, Scouters World UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: ok Moving day for me... Gizmo #178071 02/09/2007 11:44 AM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	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 http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #178072 02/09/2007 11:57 AM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	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.. http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #178074 02/09/2007 12:15 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	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? http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #178075 02/09/2007 12:33 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 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.

Re: ok Moving day for me... Rick #178076 02/09/2007 12:51 PM
Joined: Jun 2006 Posts: 869 Stan old hand
Stan old hand Joined: Jun 2006 Posts: 869	OK will do that, (even if i did a clean install?) Thanks http://clubadventist.com/forums No longer following the carrot

Re: ok Moving day for me... Stan #178108 02/09/2007 6:01 PM
Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,367 Likes: 126 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. I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum, Scouters World UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: ok Moving day for me... David Dreezer #178651 02/17/2007 6:39 PM
Joined: Aug 2004 Posts: 469 Conrad Addict
Conrad Addict Joined: Aug 2004 Posts: 469	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?

Re: ok Moving day for me... Conrad #178656 02/17/2007 7:36 PM
Joined: Jun 2006 Posts: 16,367 Likes: 126 Portland, OR; USA Gizmo
Gizmo Joined: Jun 2006 Posts: 16,367 Likes: 126 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. I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums. Do you need Forum Install or Upgrade Services? Forums: A Gardeners Forum, Scouters World UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps Longtime Supporter & Resident Post-A-Holic VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Re: ok Moving day for me... Gizmo #178679 02/18/2007 5:12 AM
Joined: Aug 2004 Posts: 469 Conrad Addict
Conrad Addict Joined: Aug 2004 Posts: 469	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.

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Profile avatar storage settings
by SenecaFlyer - 12/05/2024 1:24 PM

Not allowing attachment over 2m
by ehill - 12/03/2024 3:16 PM

New Admin Here
by SenecaFlyer - 12/02/2024 4:14 PM

Who's Online Now

2 members (Ruben, SenecaFlyer), 929 guests, and 67 robots.

Key: Admin, Global Mod, Mod

Random Gallery Image

Latest Gallery Images

Los Angeles

Los Angeles
by isaac, August 6

3D Creations

3D Creations
by JAISP, December 30

Artistic structures

Artistic structures
by isaac, August 29

Stones

Stones
by isaac, August 19

Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)