Title: Problem dumping database to another server
Last modified: August 18, 2016

---

# Problem dumping database to another server

 *  [setalosas](https://wordpress.org/support/users/setalosas/)
 * (@setalosas)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/problem-dumping-database-to-another-server/)
 * I moved my site to another server and tried to use mascon (windows client) to
   dump the old database onto the new server (both linux, old is mysql 3.23, new
   is mysql 4).
 * During the dump (using ‘dump directly to server’ option) mascon gave several 
   error messages like ‘1048 – column “pinged” cannot be null’. (Actually this was
   repeated several (7-8) times, but with different field names of different tables).
 * I tried to change each problematic field (on the source server) to set ‘allow
   null’, and retry, eventually the dump was successful! But I am a bit worried,
   why this error came up, and if my solution could make any trouble for me in the
   future?

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/problem-dumping-database-to-another-server/#post-185353)
 * Not heard of mascon.. and by the sounds of it I’ll not be seeking it out.
    Do
   you still have the original database intact, and if so, what sort of access do
   you have to that ?
 *  Thread Starter [setalosas](https://wordpress.org/support/users/setalosas/)
 * (@setalosas)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/problem-dumping-database-to-another-server/#post-185366)
 * mascon is a basic mysql admin client for windows, I use it for years for dumping
   and browsing different databases, I find it quite handy.
 * I have shell access to both the source and destination computers, and I could
   use mysql directly too. I use mascon because it’s easy to establish a dump, I
   don’t have to remember any syntax stuff. Do you think this problem is related
   to mascon and not the database itself?
 * The current database is not critical for me (it seems it works fine now in the
   new place), but in the future I’ll have to move another WordPresss blogs from
   one server to another, so I’d like to see what was the problem here…

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problem dumping database to another server’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [setalosas](https://wordpress.org/support/users/setalosas/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/problem-dumping-database-to-another-server/#post-185366)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics