Carson
May 1 2007, 04:39 AM
| | On the host I moved here from, I have a database that I would like to transfer. On this host I am unable to use PHPMyAdmin, but I have MySQL-Admin 3.3 that works fine. But the main problem is the host. Recently they made it so you there is only a 1mb upload limit, and also that MySQL temporarily will not operate properly. Which is basically why I want to get off that host. Anyway, I can export each of the small tables easily. But I have tables that are over 2mb, and I do not know how I can get them. When I click on "Show table", the table starts to load, but then it stops without finishing. The main table I want is the posts table, which is is over 2mb, and I really need to get it in order to move off the host. I am really stuck, and need help. Can anyone give me some advice on what I can do? |
Reply
nocom
May 1 2007, 01:25 PM
You need more internet speed to see full table ,then download part of table wich is under 1MB ,couple steps and you get database.If you have same problem again please temporarily slose the site to gain more bandwidth from server .Some servers count connections from single IP address and then block them or limit bandwidth. .......I hope that is helpful
Reply
jlhaslip
May 1 2007, 01:29 PM
Can you use a 'back-up' feature of their 'c-panel' to store a copy locally, re-create the database in the new location and re-store to the second database from the 'back-up'?
Reply
Carson
May 4 2007, 03:25 AM
Actually, they do not have C-Panel. So I cannot make a back-up locally. I did find a program that may help me export my database though. It's called MyBackup, and it allows you to backup your database on your host locally. The only problem is, I cannot get the FTP settings to work properly, so I cannot use the program. Here is a screenshot of what the FTP settings box looks like:  I think I can use my trap17 account's FTP settings for this, right? I use a subdomain with trap17, so can anyone tell me the details that I need to enter? I have had no luck so far with what I've tried. It always comes up with the message: QUOTE * FTP settings are incorrect. Enable to Connect ftp. Thank you for the help.
Reply
Similar Topics
Keywords : exporting database problems- Database Or Pdf
- Best way to list books on my site (1)
- Database With Mysql++
- getting mySQL++ to work with trap17 (7)
Hi, I'm trying to build an online game and figured the easiest way to do the server list would
be to make a mySQL database for it; however, I use the con() command on the IP i get from pinging my
website and I always get an abnormal program termination; however, it will work with the mySQL on my
own machine. The code is below: CODE #include <iostream> #include <iomanip>
#include <mysql++> #include "pass.h"//holds my password (i program at
school) int main(void) { Connection con("t3jem3_test","...
Problems With Apache Alias
- I want to install RPG Web Profiler (0)
Hello, I want to install RPG Web Profiler on my web site. It seems easy with a very few steps but
I have never worked with Apache before. The readme of setup. This is the step I couldnt
understand, the last step. QUOTE 5. Create the following entry in my Apache configuration.
Alias /profiler "/home/tarlen/profiler/public_profiler" AllowOverride All Order
allow,deny Allow from all By the way, Im using Trap17 CP. ...
What Value Would I Use To Insert This Data?
- Help on insertion of data to database? (4)
I am learning slowly but surely and I know some of you probably getting tired of my questions. ^^;;
However, I believe one can not learn without asking questions. So.. if I get too bothersome.. just
point me to some books or something. lol XD // Make a MySQL Connection mysql_connect("localhost",
"name", "password") or die(mysql_error()); mysql_select_db("at2927_abq") or die(mysql_error()); //
Insert a row of information into the table "example" mysql_query("INSERT INTO members (pasture)
VALUES('Timmy Mellowman', '23' ) ") or die(mysql_error()); ...
Mysql Query Problems
- I need some help or a tutorial? (6)
I seem to be having trouble with getting my Query to post my user's ID numbers. CODE //
Make a MySQL Connection mysql_connect("localhost", "user",
"password") or die(mysql_error());
mysql_select_db("databasename") or die(mysql_error()); // Retrieve
all the data from the members table $result = mysql_query("SELECT * FROM members WHERE
id='$id'") or die(mysql_error()); // store the record of the
id table into $row $row = m...
Forum Database
- Forum Database Space and its capacity to hold content (9)
Okay, I have a forum which is growing daily. Even though members aren't that many, I'm still
concerned over my database space and its capacity to hold the forum's content. Since post counts
take up database space, the remaining space will decrease daily, albeit by little amounts. Still, it
will decrease anyway and eventually my database for that forum will run out of space. My question
is: 1. Is there any way to possibly create a new database to continue holding the old
database's increasing data? As in, my old database is there but its full and I creat...
Php With Simple Csv List As Database, What Do U Think?
- (2)
I've designed a php website and i used simple CSV file as my database because of few reasons
my client had to pay more to active MySQL database was a simple product list it was easy to
convert product list from existing Excel file to CSV it is easy to make any changes so i have few
files to convert to CSV if i wanna update the website. I know it's less secure specially if
it's an online business (which is not). question is : what are disadvantages? is that slower
than MySQL? is there more possibility of occurring bug? is that less professional? or .....
Database Migration - Seditio To Joomla
- any help is needed (1)
Hi guys! I was desperately looking on internet for any help with migrating Seditio database to
Joomla.. I`m admin on site which has more than 2500 members and day by day I get annoyed by
pretty dumb solutions in Seditio.. can anyone tell me how to migrate the seditio site to joomla?
any tutorials on internet on database migration? thanks...
Best Database Software?
- (1)
I'm quite new to creating and managing databases - yesterday I installed Filemaker Pro 9 and my
initial thoughts are that it's amazing! Only just starting to get to grips with it - think
it'll take some time to master it. What Database software do others use and what do people
think of Filemaker Pro? Advantages/Disadvantages? ...
Connecting Php With Oracle Database
- (1)
i need to connect oracle with php ..now me using oracle 10g can any one give me the solution
thanks....
Questioning My Database Structure...
- (4)
Okay, I posted a brief description of this in the PHP section, but I'll summarize myself again.
I'm creating a PHP based game that is an economy game, where you start out with so many
resources and a building, and you expand your business empire by building more buildings, which puts
out more resources, and you can buy and sell on the market and whatnot. In the end, you try and
become the wealthiest player in the game. Now I already have most of my database in MySQL set-up.
But I've been told several different things on my structure and wanted your guys'...
Mysql Database Copying
- (4)
Is there anyway to merge 2 databases? I have an XOOPS and SMF both installed with Fantastico, and
the bridge is not working like the Joomla! one does. (with the seperate db capability) i know
how to transfer all the tables by hand but depending on how much data you have stored in mysql could
take a long time. Take short time!? Help me!...
How To Connect Site To Database? [resolved]
- (12)
I created a table in phpmyadmin, i copied the code in a file and uploaded this file onto the host.
Now it says that it cannot connect to the database. The error lies within
"mysql_select_db($db)" => so i think this means that it cant find the database? If anyone knows
how to let my login and register forms connect to the database, please help me. I used a login
system from this site, ill post the link later....
Joomla Sql Error: Connection To Database Server Failed.
- (1)
Hi Today I got this error-message in back-end on my Joomlasite hewwelub.trap17.com/d-lan/
QUOTE This site is temporarily unavailable. Please notify the System Administrator Connection to
database server failed. This is the first time I get this error, and I don't want or have
the time to reinstall the site with all its features... The only time I have seen this problem yet
is when I tried to unpublish a menu item. Any answer would be to great help, thanx /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />...
Sqlserver 2005 - Login Problems
- (0)
Hi guys, I just installed sqlserver2005 and when i open server management studio and try to connect
I chose SQL server authentication mode it then asks me for a login and password. I have no idea what
this is. Is there a default? or do i need to add a login somewhere. I may have not specified one
when installing. Any ideas? Cheers, Paul...
Mannual Creation Of Oracle Database
- (0)
Manual Creation of database in windows with oracle 9i (Step-by-Step) (Name of the database=db18)
(Note: all commands are in bold letters) 1. Open the command prompt and execute the command
sqlplus/nolog 2. Connect to the default database as sysdba in sql prompt SQL>conn sys/oracle as
sysdba you can see the name of that database by executing select name from v$database; 3. Now
open another command prompt and set oracle SID as set oracle_sid=db18 4. Start a windows service
with internal password oradim –new –sid intpwd is the syntax. In this case I use ceylonlinux...
Mysql Tools Database
- Opensource sql tools... (1)
You can download mysql query web browser on http://www.mysql.com you also can download plugin
there...like conector mysql from visual basic ,java,etc with my sql query tool browser you can make
and maintance youre database sql easily because use gUI interface..!!...
Looking for exporting, database, problems
|
|
Searching Video's for exporting, database, problems
|
advertisement
|
|