Go Back   Admin Zone Forums > The Development Zone > Databases and File Storage

Databases and File Storage Discuss database applications like mySQL and Postgres or other methods of storing data on the server.

Reply
 
Thread Tools

  #1  
Old 03-30-2012, 09:40 AM
Lenka's Avatar
Lenka Lenka is offline
Tazmanian
 
Real Name: Lenka
Join Date: Nov 2006
Admin Experience: Advanced
Location: Denmark
Age: 37
Posts: 351
Lenka is on a distinguished road
Default New server (Ubuntu/apache) - mysql problems
(if you just want to read my final question, just skip the chit chat and go to the buttom! *)

I have just got access to my new server some days ago. Right now I am installing and testing and moving my smaller testpages over to test.

I have got my virtual hosts up and running so I can see my moved web pages - check.

I can connect to mysql through the command line and have moved some of the databses/tables from the smaller pages - check.

Then I had some problems with connecting through the database through net, but after som research I realized it was a premission problem and corrected the premissions for the databasefiles. Check.

And then I thought it still didn't work, but realized it was me being stupid and checking the wrong folder, ups - dubbelcheck

...

Anyway ... now I have made a small test of my forum. Too
k the latest mysqldump from last night and a copy of all the files and pointed a test-domain to my new server. Set up everything for the test. And I just get a stupid IPS driver mysql error.

And I just realized that my mysqldump is not complete, since one of my tables are broken/missing (the ibf_profile_portal_views - i have known this all along, but cannot seem to fix it for good). So all tables after that one are missing.

Good thing I haven't promised I would move the site tonight, but said "this weekend - probably" - but I really would likew to be able to do it tonight!

So moving on with the test ... and besides the chit chat, here comes a question (maybe one of many):
* is it possible to make a mysqldump of all tables that comes after a certain table (alphabetically)?
__________________
Admin of a "motherboard"

Last edited by Lenka; 03-30-2012 at 09:46 AM..
Reply With Quote
  #2  
Old 04-02-2012, 02:58 AM
tbofram's Avatar
tbofram tbofram is offline
That cool member
 
Real Name: justin
Join Date: Feb 2011
Admin Experience: Intermediate
Location: Scotland
Age: 19
Posts: 957
tbofram is just really nicetbofram is just really nice
Default
I'm sure you can skip the tables you have (including the broken) and go from there. Or couldn't you just try and remove this broken table and do a new dump?
Reply With Quote
  #3  
Old 04-02-2012, 03:17 AM
The7thSage's Avatar
The7thSage The7thSage is offline
Tazmanian
 
Join Date: Aug 2011
Admin Experience: Advanced
Posts: 298
The7thSage is a glorious beacon of lightThe7thSage is a glorious beacon of lightThe7thSage is a glorious beacon of light
Default
Can't you recreate that table without any records? That table doesn't sound like it would contain much important data.

Now considering that it does contain important data, do what tbofarm said, make a new dump of that table and import it. No need to dump all other tables unless they too are broken.
Reply With Quote
  #4  
Old 04-02-2012, 04:48 AM
Lenka's Avatar
Lenka Lenka is offline
Tazmanian
 
Real Name: Lenka
Join Date: Nov 2006
Admin Experience: Advanced
Location: Denmark
Age: 37
Posts: 351
Lenka is on a distinguished road
Default
I have fixed the problem by deleting the broken table alltogether and then make a fix through the ACP (which basically created a new table I guesss)

Thanks for suggestions!

I have moved the site to the new server two days ago, now fixing small bugs.
__________________
Admin of a "motherboard"
Reply With Quote
  #5  
Old 04-02-2012, 11:27 AM
tbofram's Avatar
tbofram tbofram is offline
That cool member
 
Real Name: justin
Join Date: Feb 2011
Admin Experience: Intermediate
Location: Scotland
Age: 19
Posts: 957
tbofram is just really nicetbofram is just really nice
Default
Quote:
Originally Posted by Lenka View Post
I have fixed the problem by deleting the broken table alltogether and then make a fix through the ACP (which basically created a new table I guesss)

Thanks for suggestions!

I have moved the site to the new server two days ago, now fixing small bugs.
great hopefully your nice new server will run smooth
Reply With Quote
  #6  
Old 04-02-2012, 02:57 PM
forumhookers forumhookers is offline
Tazmanian
 
Real Name: Siddharth
Join Date: Dec 2011
Posts: 202
forumhookers is on a distinguished road
Default
If you need any further help pm me. I help all for free
__________________
Fastly Growing Forum- Forum for Webmaster,Gamers,Programmers,Professionals and Students.
Download HD Wallpapers in Multi Size
Reply With Quote
Reply

  Admin Zone Forums > The Development Zone > Databases and File Storage





Currently Active Users Viewing this Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I need advice to tweak PHP, Apache and MySQL for my vps. Xtreme2damax Servers and Hosting 32 06-29-2010 02:07 PM
PHP+MYSQL+apache windows bundle? cyberxp9 Getting Started 9 12-02-2008 04:27 PM
Beginners guide to installing Apache, MySQL and PHP? Ogden2k Servers and Hosting 3 08-22-2006 01:18 AM
Help me to configure MYSQL (and apache if possible) DomZ Servers and Hosting 0 07-22-2006 05:23 PM
PHP, MySQL, and Apache config questions... techkid vBulletin 4 06-03-2006 08:03 AM


 

All times are GMT -4. The time now is 04:34 PM.


Powered by: vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Page generated in 0.06863093 seconds with 15 queries
The Admin Zone copyright 2003-2014 All Rights Reserved. Content published on The Admin Zone requires permission for reprint.