[support] large db problem thanks to displaysuite

[Jim Ruby]

Here is what I tried. I took the db made by backup and migrate and imported
it in to a  new db different name using phpmyadmin
I updated the settings.php
Still no go.
I took out all the ds.* tables I could find using phpmyadmin, I just deleted
them. I believe I browsed the system table and found them in there. Maybe I
did it wrongt.

Still no go.
I then tried a manual backup I made with backup and migrate and it gave me
yet an error, so I'm wondering if I have bad backups with backup and migrate
al though I used their default configuration. I do see all the cache tables
in there too that got restored, so could that be giving me a problem..

:( hope I can get all the data I entered back, it was a lot.

Thank you for your reply.




Follow me on:
Twitter: http://twitter.com/1rubytweets
Facebook: http://www.facebook.com/profile.php?id=1058306793
Join me on:
Yahoo: jruby6767
Msn: jruby at charter.net


-----Original Message-----
From: Jeff Brown [mailto:jeff at wildcoast.com] 
Sent: Wednesday, September 21, 2011 2:50 AM
To: support at drupal.org
Cc: Jim Ruby
Subject: Re: [support] large db problem thanks to displaysuite

More I think about it, the more likely I think it is that you're 'migrating'
to the same database name and therefore the corrupted tables are still
there.

Are you working on a LAMP server?

If so, do this before restoring:

mysqladmin -p drop databasename


Else drop it with phpmyadmin.

HTH

On 21 Sep 2011, at 6:47 AM, Jim Ruby wrote:


	Ok, if I can not get this fixed, would there be a way to at least
some how
	drop the node table in to my new db so I do not have to go through
all the
	hours of working on entering it again. I have tried other backups
using
	backup and migrate but even when I go way back I am getting an
error. I am
	just using the default profile with my default db I have a couple of
manual
	backups and 7 days worth of scheduled backups and I have a few
before I
	installed displaysuite.
	
	What happen is I went to adjust the path in modules content "my
show" filed
	I created I clicked on I believe it was edit fields" sorry I can't
remember
	the exact one I have no drupal 7 to look at right now, but it is
where you
	can adjust and configure your fields and it just blew up at that
point.
	
	Now display suite did not install and had an error and I read that
they have
	a fix, but I can't install it if I can not even get access. At any
rate any
	suggestions on how I can gain my site back even if I have to start
from
	scratch, I am hoping there might be a way I can at least get my
nodes back I
	can create the views easily enough thanks to others help on the list
here.
	
	I do have backups, but I can't seem to get them going so are the
defaults
	not good to use in the backup and create migrate script. I'd rather
have the
	site blow up now and not when it is been life for a few weeks.
	
	Thanks for any heop and sorry for cluttering up the list with this
	
	Follow me on:
	Twitter: http://twitter.com/1rubytweets
	Facebook: http://www.facebook.com/profile.php?id=1058306793
	Join me on:
	Yahoo: jruby6767
	Msn: jruby at charter.net
	
	
	
	-- 
	[ Drupal support list | http://lists.drupal.org/ ]